Error with MySQL syntax

Ok, I have made a generator for SQL queries, which normally works, but this one query doesn't:

INSERT INTO groups (name, read, write, edit, delete, comment, admin) VALUES ('Guest','1','0','0','0','0','0' )

Code (markup):

The PHP error says "MySQL Syntax error around here:

 ('Guest','1','0','0','0','0','0' )

Code (markup):

 

Don't know for sure but maybe if fails because words like 'read' and 'write' are reserved words, try adding backticks like `read`

see http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html

 

"delete" is another reserved word.

It is good practice to always enclose table and field names in `backquotes`. It's a hard habit to get into at first, and a lot of times you will accidentally press Esc instead of the key below it, but eventually it will become second nature and you will be able to avoid situations like this one.

 

Righteo thanks, I'll test later tonight.

 

Here is the mysql reserve words.