Updating last login date

[davidcriniti]

I'm making an amendment to my login page so that when a user logs in, the date_last_login field in the members table is updated to NOW(). Well, that's the idea.

 

The login works fine. Always has. It's just this update that isn't happening. No error message appears, but date_last_login remains 0000-00-00 00:00:00 . Any tips?

$sql_date_last_login = $pdo->exec("update members set date_last_login = now() where member_id = '".$SESSION['member_id']."'");

Cheers,

Dave

[davidcriniti]

Oops,

 

found the error:  (Missing "_" in $_SESSION)

$sql_date_last_login = $pdo->exec("update members set date_last_login = now() where member_id = '".$_SESSION['member_id']."'");