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