I'm trying to set up a database that tracks system downtimes.
I would like to have a date and time stamp auto insert into a form field so that it can be used as a key field, this will also serve as the incident identifier for lookup purposes. Keeping the date in the format MySQL likes is fine with me.
I am using Dreamweaver MX 2004 and am fairly new to both DW And MySQL.
Any help, suggestions or points in the right direction would be appreciated.
Thanks,
Ray

why not let the INSERT statement provide a datetime value at the moment it is entered into the database

then you won't need a form field at all

by the way, it is more common practice in these situations to use an auto_increment number as the identifier

but if you realy want to add a datetime to mysql do it this way

the string should have this format
"YYYY-MM-DD HH:MMS"
for example "2005-01-17 17:18:31"

otherwise just use NOW() in the insert statement
something like this
INSERT INTO mytable VALUES ( ....., NOW(), ....)