[RESOLVED] date time problem

[kingdm]

Hello there,

I have this query to update my users database.

$updateQuery = "UPDATE wnl_users
			   SET
			    `usr_isFirstLogin` = FALSE,
			    `usr_lastLogin` = CURDATE()
			   WHERE
			    `usr_id` = '".$_SESSION['id']."'
			   ";

Specifically my concern here is the usr_lastLogin column. It's mysql type set is DATETIME, but when I run the query all I get is '2011-03-23 00:00:00'. I want to save the time as well. Any ideas?

Thanks.

[kingdm]

Fixed. Changed CURDATE() to NOW(). :p