cursed Posted January 24, 2010 Share Posted January 24, 2010 Hey all, So I've been failing at writing PHP code for the last couple days, any help would be great. So I get this error: 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 'key, title, content, url) VALUES('google wave', ' WebJunction Group: Google Wave' at line 1 The line of code is: mysql_query("INSERT INTO content (key, title, content, url) VALUES('$key', '$title', '$page', '$link')") or die(mysql_error()); The funny thing is, when I remove the column KEY and it's value, it works fine. (It would look like mysql_query("INSERT INTO content (title, content, url) VALUES('$title', '$page', '$link')") or die(mysql_error()); ) I've added slashes and it does exist (I echo it before I input it, just to show i'm not crazy) Thanks in advance for the help, love you guys. Quote Link to comment https://forums.phpfreaks.com/topic/189587-stupid-q-insert-in-column-error/ Share on other sites More sharing options...
premiso Posted January 24, 2010 Share Posted January 24, 2010 http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html Key is a reserved word. Either enclose the column title in backticks ( ` ) or rename the column name. Quote Link to comment https://forums.phpfreaks.com/topic/189587-stupid-q-insert-in-column-error/#findComment-1000652 Share on other sites More sharing options...
cursed Posted January 24, 2010 Author Share Posted January 24, 2010 Awesomeness. Thanks so much! Quote Link to comment https://forums.phpfreaks.com/topic/189587-stupid-q-insert-in-column-error/#findComment-1000654 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.