Actually it would be:
UPDATE table SET dateTime=NOW() WHERE record_id='$the_one_you_want';
Or
INSERT INTO table (record_id,dateTime) VALUES
('$the_one_you_want',NOW());
Gary Every
Sr. UNIX Administrator
Ingram Entertainment Inc.
2 Ingram Blvd, La Vergne, TN 37089
Pay It Forward!
-Original
[EMAIL PROTECTED] wrote:
Hi all,
i have a datetime field in a mysql database and it's defined with a default
of '-00-00 00:00:00:'
now, when i add a record to the database, i want to fill that field with the date and
current time.
can anyone point me ?
Via PHP:
$dateTime = date('Y-m-d