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 H:i:s');
mysql_query(INSERT
Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 10, 2004 4:10 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: datetime update
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
[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