hi,
i have created a mysql table where i would like to store the date and time
whenever a user logs into a web site. the login is done through php/mysql as
well but i'm not sure what the php code is to add the current date/time into
a mysql database. the field in the db is created as a 'datetime'
You can do it in SQL:
INSERT
...
SET col = NOW()
Ignatius
_
- Original Message -
From: ..: GamCo :.. Gawie Marais [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 04, 2004 14:35
Subject: [PHP-DB] Php datetime
hi,
i have created a mysql table
-
From: ..: GamCo :.. Gawie Marais [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 04, 2004 8:35 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Php datetime
hi,
i have created a mysql table where i would like to store the
date and time
whenever a user logs into a web site. the login is done
I've heard you want to use a TIMESTAMP field for that.
i have created a mysql table where i would like to store the date and time
whenever a user logs into a web site. the login is done through php/mysql
as
well but i'm not sure what the php code is to add the current date/time
into
a
Daniel Clark wrote:
i have created a mysql table where i would like to store the date and
time
whenever a user logs into a web site. the login is done through php/mysql
as
well but i'm not sure what the php code is to add the current date/time
into
a mysql database. the field in the db is
