You can do it in SQL: INSERT ... SET <col> = NOW() Ignatius _________________________ ----- Original Message ----- From: "..: GamCo :.. Gawie Marais" <gawie@xxxxxxxxx> To: <php-db@xxxxxxxxxxxxx> Sent: Thursday, March 04, 2004 14:35 Subject: 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 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' field. > > > > > > > > > > Regards, > > > Gawie Marais > ..: GamCo :.. > > -------------------------------------- > Tel: +27 11 312 0481 > Fax: +27 11 312 0483 / +27 82 239 2986 > http://www.gam.co.za > -------------------------------------- > if(empty($beer)) > { getbeer() } > else > { consume($beer) } > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php