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:
[EMAIL PROTECTED] 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...
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
