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