Re: inserting timestamp into mysql field

Not really a MySQL question - the answer happens to be MySQL, but the question asks how to do it in PHP This might still be necessary if the OP is using something like DB_DataObject, as you can't really use NOW() in that situation Try strftime [ http://uk.php.net/strftime - RTFM :) ] - a good format string would be "%Y-%m-%d %H:%M:%S" which will produce 0000-00-00 00:00:00 Marek Kilimajer wrote:

luke@lukem.co.uk wrote:

Subject: inserting timestamp into mysql field hi there, i need to insert a current timestamp into a mysql field when a form is posted. can anyone suggest a simple way of doing this? i would like to set a variable in my php script to add into the insert statement. it needs to be in the format 00-00-00 00:00:00.

insert table set ......, date_added = NOW() mysql question by the way...