Timestamp in MySQL database

I’m a complete MySQL newbie, so any answers to my question in small words that a child could understand would be appreciated. :thumb2:

I’ve created a table in MySQL using PHPMyAdmin which is updated from a PHP file with data from an online survey. I want to somehow insert a time and date stamp into the table for each entry.

I’m assuming this is something to do with the ON UPDATE CURRENT_TIMESTAMP attribute, but when I try and add this to a row in the table I get an error message - #1294 - Invalid ON UPDATE clause for ‘id’ column.

What am I doing wrong, and what should I be doing?