Page 1 of 1

lastlog update

Posted: Mon Apr 10, 2006 5:52 pm
by mbshaf4
I am trying to write a script that will update a users databse with the last date they logged in. This is the query i tried

$query = "UPDATE user SET lastlog=CURDATE() WHERE email='$e' AND password=SHA('$p')";

Is there anything that you guys see wrong with it.

Can you suggest how to do it?

Thanks in Advance

Posted: Mon Apr 10, 2006 10:47 pm
by feyd
have you tried seeing what mysql_error() says?