ID: 17023
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
-Status: Open
+Status: Bogus
Bug Type: MySQL related
Operating System: Linux
PHP Version: 4.2.0
New Comment:
Lose the ; and it will always work. The ; is not needed from
mysql_query().
Not a bug -> Bogus.
Previous Comments:
------------------------------------------------------------------------
[2002-05-05 19:31:10] [EMAIL PROTECTED]
Note the trailing whitespace in query:
<?
mysql_select_db("test");
mysql_query("select * from tab; ");
echo mysql_error();
?>
Result:
You have an error in your SQL syntax near '; ' at line 1
Again, note the trailing whitespace. Without it, it's OK.
It's particullary annoying with heredoc syntax.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=17023&edit=1