I am a complete newbe, I am inserting a record into a MySql db from a form on a Dreamweaver page. The form has only two fields, zip code and email. I setup table in the db to have five fields, an id number, zip code, email and date. I would like the date to reflect the date the record was inserted into the db. How would I do that?

Thanks for any help.

if yout date colum is in a datetime or timestamp format, use the sql function "now()"

insert into myTable (dateCol) values ( now() );

Also, depending on how your field is set up, if the default is CURRENT_TIMESTAMP, you can just insert NULL, and it will be automatically handled for you.

Thank you for the suggestions, I found the timstamp field and that worked perfect.