|
Posted by bobmct on 07/18/06 17:43
In my feeble attempt to keep track of login session timeouts I have the
following code in my login section of my program:
$sql = "UPDATE subscriber
SET _sessexp = 'DATE_ADD(NOW(),INTERVAL 15 MINUTES)'
WHERE _userid = '$_userid'
LIMIT 1";
and when run I see NO ERRORS. However, either the field in the DB doesn't
change OR this expression is generating a value of '0' for the _sessexp
field.
I've tried using the ADDTIME function as an alternative but get the same
results. I'm kind of at a loss.
Any ideas as to why this is NOT behaving as I expect it to?
What I am attempting to do is to take the CURRENT TIME and add 15 minutes to
it and update a field in the database record. That simple!
Bob
Navigation:
[Reply to this message]
|