whats wrong with this mysql insert

[aquanuke]

mysql_query("INSERT INTO invoices

( client, date, domains, items, each, cost, status) VALUES('$custom', '$date', '$item_number Domain Credits', '1', '$mc_gross', '$mc_gross', 'PAID' ) ")

or die(mysql_error());

 

gives me 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 'each, cost, status) VALUES('admin', '2011-09-01', '10 Domain Credits', '1', '15'' at line 2

 

Using crimson editor the fields im selecting 'date' and 'each' are in red. Are they not allowed? me thinking out loud

 

 

[Pikachu2000]

each is a MySQL reserved word.

[aquanuke]

Thanks thats what I thought, so is there a way to escape it like enclose the fields?

 

I cant change the db fields as this table has been in use for about 7 years and tons of references to it elsehwere in other scripts.

[Pikachu2000]

Enclose it in `backticks` in the query string.

[aquanuke]

Thank you !