#26855 [NEW]: UPDATE query unexplicable behavior

From: superzouz at hotmail dot com Operating system: various PHP version: 4.3.4 PHP Bug Type: MySQL related Bug description: UPDATE query unexplicable behavior Description: ------------ When I run the following query through PHP: UPDATE config_intranet SET confvalue = '192.168.0.1' WHERE confkey 'vpn_server_ip' I get the following error. 1064: You have an error in your SQL syntax near 'query' at line 1 But if I type the same query directly into MySQL, it is executed correctly! I was able to reproduce this situation on my PC (Windows XP SP1) with PHP 4.3.4 and MySQL "client api version 3.23.49", and on 2 internet hosting providers running PHP 4.x with mySql on *nix systems, so it is not an issue with my configuration. There is nothing in the official PHP docs stating that a query would be handled differently by PHP and MySQL. Thanks Reproduce code: --------------- $conn = mysql_connect ( "localhost", "rolfen" , "" ); mysql_select_db("dergham", $conn); $query = mysql_real_escape_string("UPDATE config_intranet SET confvalue = '192.168.0.1' WHERE confkey = 'vpn_server_ip'"); $res = mysql_query(query, $conn); if ($res) echo "success"; else { die("Error while updating config table. Error Output: <br/>". mysql_errno() . ": " . mysql_error(). "<br/>"."Query follows:<br/>".$query); return False; } ?> Expected result: ---------------- success Actual result: -------------- Content-type: text/html X-Powered-By: PHP/4.3.2 X-Powered-By: PHP/4.3.2 Content-type: text/html Error while updating config table. Error Output: <br/>1064: You have an error in your SQL syntax near 'query' at line 1<br/>Query follows:<br/>UPDATE config_intranet SET confvalue = \'192.168.0.1\' WHERE confkey = \'vpn_server_ip\' -- Edit bug report at http://bugs.php.net/?id=26855&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=26855&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=26855&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=26855&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=26855&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=26855&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=26855&r=needscript Try newer version: http://bugs.php.net/fix.php?id=26855&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=26855&r=support Expected behavior: http://bugs.php.net/fix.php?id=26855&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=26855&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=26855&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=26855&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=26855&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=26855&r=dst IIS Stability: http://bugs.php.net/fix.php?id=26855&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=26855&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=26855&r=float