Whats wrong?

[Bman900]

I have this code:

 

mysql_query("CREATE TABLE key_page(

id INT NOT NULL AUTO_INCREMENT,

PRIMARY KEY(id),

keyword VARCHAR(30),

page VARCHAR(30),

age INT)")

or die(mysql_error()); 

 

echo "Table Created!";

 

mysql_query("INSERT INTO key_page

(keyword, page) VALUES('keyword1', 'page1.php' ) ")

or die(mysql_error());

 

And when I run it I get this:

 

Connected to MySQL

Connected to DatabaseTable Created!

Unknown column 'keyword' in 'field list'

 

Obviously that column is there, i even checked in the database itself....

[hitman6003]

place the column name in backtics (the key next to 1, with the tilde ~).

 

INSERT INTO key_page (`keyword`, `page`) VALUES('keyword1', 'page1.php' ) 

[Bman900]

wow that doesn't make sense but it sure worked!

[the182guy]

MySQL doesn't like you having certain field names unless you in enclose them in ``, "keyword" being one of them. Same problem occurs if you try to use "date" or another data type as a field name.

[Maq]

MySQL doesn't like you having certain field names unless you in enclose them in ``, "keyword" being one of them. Same problem occurs if you try to use "date" or another data type as a field name.

 

To elaborate on this, which is 100% correct BTW, there are a handful of words that are "reserved" for MySQL and must be escaped with backticks `.

 

For more information and to see the entire list: Reserved Words.