Jump to content

Stupid Q: Insert In Column Error


cursed

Recommended Posts

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.

 

Link to comment
https://forums.phpfreaks.com/topic/189587-stupid-q-insert-in-column-error/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.