I have a MySQLi prepared statement I'm trying to run to simply update a couple columns, but for some reason, it will not work. The statement runs without throwing any errors, and if I try to change any other column in the table, those columns update just fine, but the problem columns never will. Even if I update both in the same statement! However, if I copy the query into MySQL and run it, it works just fine, updating all columns. It only fails to work completely when running the query through MySQLi in the code.I'm so frustrated that a single update, updating two columns, will run without error and update one of the columns but not the other. What am I doing wrong?Here's the statement:\[code\]$query2 = "UPDATE company SET city='minot', card_image_id = 0, card_use_cropped = 0 WHERE company_id = ?";if (!$stmt = $mysqli->prepare($query2)) { throw new Exception("Prepare failed: (" . $mysqli->errno . ") " . $mysqli->error);}if (!$stmt->bind_param("i", $company_id)) { throw new Exception("Binding parameters failed: (" . $stmt->errno . ") " . $stmt->error);}if (!$stmt->execute()) { throw new Exception("Execute failed: (" . $stmt->errno . ") " . $stmt->error);}\[/code\]The column \[code\]city\[/code\] is \[code\]varchar(15)\[/code\] and updates just fine. \[code\]card_image_id\[/code\] and \[code\]card_use_cropped\[/code\] are \[code\]int(11)\[/code\] and \[code\]tinyint(1)\[/code\] (bool), respectively, and will not change no matter what I do.Please let me know if any other information could be helpful.