[SOLVED] Extremely Simple usage of INSERT just wont work

[Slips]

Hi,

 

I've encountered this really frustrating problem which wont allow me to do a mysql insert, it started off with a bigger code with variables and arrays but finally i started erasing lines and finally came down to this and it still gives me a sql syntax error!!!! Help would be greatly appreciated, since i have been stuck on this for an hour now, yes an hour.

 

The error i get is :

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,state) VALUES('key','value')' at line 2

 

If i try the exact same code and just replace the tablename with some other table and its respective fieldnames, it works just fine, its like as if this code doesnt like the current table.

 

I tried recreating the table and it didnt help.

 

 

 

 

 

<?php
require 'dbconnect.php';
mysql_select_db($generaldb,$link);
mysql_query("INSERT INTO locationkeys
(key,state) VALUES('key','value') ") 
or die(mysql_error());  
?>

[kickstart]

Hi

 

Think key is a reserved word. Either surround it in back ticks in the SQL or (personally better) change the name of the column to something that isn't a reserved word.

 

All the best

 

Keith

[Slips]

Damn, i never would have guessed that..Thanks a ton. In my opinion mysql shouldnt allow us the create the table in the first place if it contains that fieldname. The error statement is kinda misleading..

[fenway]

In my opinion mysql shouldnt allow us the create the table in the first place if it contains that fieldname.

It doesn't ... unless you (or your IDE) used backticks.