MySQL Error
Posted: Tue Mar 09, 2010 8:11 pm
Hello everyone,
I am receiving this error while developing a PhP/MySQL application:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''id', 'pointkey', 'ptop', 'pleft', 'pOrder', 'mapKey', 'userName', 'title', 'des' at line 1
Here's the full query:
The $-signed variables I am pretty clear that I have already set. Any kind help from board members would be greatly appreciated. Thanks,
Chi
I am receiving this error while developing a PhP/MySQL application:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''id', 'pointkey', 'ptop', 'pleft', 'pOrder', 'mapKey', 'userName', 'title', 'des' at line 1
Here's the full query:
Code: Select all
mysql_query("INSERT INTO points ('id', 'pointkey', 'ptop', 'pleft', 'pOrder', 'mapKey', 'userName', 'title', 'description', 'more') VALUES (NULL , '$gKey', '', '', '', '$mapKey', '$userName', 'New Point', '','');") or die(mysql_error());Chi