Problem with inserts in MySQL

[techek]

I've got a big problem!

I've made a PHP-script with a "simple" insert into MySQL, but the query fails big-time. Now I've tried the query in phpMyAdmin and ofcourse the same thing happens :

SQL-query :

INSERT INTO banner_log SET banner_id=6, when=NOW(), action='view'

MySQL said:
You have an error in your SQL syntax near 'when=NOW(), action='view'' at line 1

MySQL is vers. 3.23.49 and the table is of the MyISAM-type. The same query worked perfect before when I was running at another system (earlier version of MySQL but quite up to date and with no MyISAM-tables)

As a note, the dump I made from the "old" system had to be altered because creation of a datetime-column caused it to fail when imported. So I took out the line and used ALTER after table-creation to create the column with DATETIME. Kinda weird!

Any suggestions to the problem / error of mine are VERY welcome!!!

/Techek

[Anon]

What are the field data types for banner_id, when, and action? From the look of your SQL banner_id is an inetger, when is a datetime and action is some sort of string.

[Anon]

Don't use when as a column name, it is a reserved word in SQL.

[techek]

Perfect! Now it works - when you come to Denmark I'll give a beer or two!

/Techek