Re: [PHP-DB] Php datetime

2004-03-04 Thread Hans Lellelid
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

Re: [PHP-DB] Php datetime

2004-03-04 Thread Daniel Clark
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

RE: [PHP-DB] Php datetime

2004-03-04 Thread Hutchins, Richard
; -Original Message- > 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

Re: [PHP-DB] Php datetime

2004-03-04 Thread Ignatius Reilly
You can do it in SQL: INSERT ... SET = 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, &

[PHP-DB] Php datetime

2004-03-04 Thread ..: GamCo :.. Gawie Marais
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'