Posted by Rik on 07/18/06 17:56

bobmct wrote:
> 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!

First of all, you try to add the string 'DATE_ADD(NOW(),INTERVAL 15
MINUTES)' to a date field, which is invalid and will result to 0. Remove the
quotes.
Grtz,
--
Rik Wasmus

[Back to original message]