Updating a TIMEDATE feild using SQL alongside PHP

[ATM]

Hello,I know this is an easy question, but I'm not currently very good at SQL and would like to know how to update a TIMEDATE field.Currently I'm trying to use

$current_timestamp=mysql_query("SELECT CURRENT_TIMESTAMP");$mysql_update_last_login=mysql_query("UPDATE account SET last_login='" . $current_timestamp . "' WHERE user_id='1');

[Kristian_C]

Hello,I know this is an easy question, but I'm not currently very good at SQL and would like to know how to update a TIMEDATE field.Currently I'm trying to use

$current_timestamp=mysql_query("SELECT CURRENT_TIMESTAMP");$mysql_update_last_login=mysql_query("UPDATE account SET last_login='" . $current_timestamp . "' WHERE user_id='1');

I dont know much about timestamp but i really think it is easyer to add it as DATETIME insted of timestamp if you just want to update the date when a user logs in.etc :$logintime = gmdate('Y-m-d h:i:s');mysql_query("UPDATE account SET last_login='$logintime' WHERE user_id='1'");->Kristian_C