Automaticaly inserting date

[oo7ml]

Hi, i have just created a new field in my database called date. When a user submits a join form i want the date/time to be automatically inserted into the date field in the database.

I already have the value NO automatically inserted into the valid field in my database when a user submits a join form, so i just need to add the data/time function under this

$valid = 'NO';

Can someone please show me how to do this, thanks

[oo7ml]

anyone...

[bokeh]

Why not have a DATETIME column with a default set to NOW().

[oo7ml]

Wow, that would be cool, how would i do that, thanks

[bokeh]

It is possible to have the current timestamp be the default value for initializing the column... (http://dev.mysql.com/doc/refman/5.0/en/timestamp-4-1.html)