Posted by bobmct on 07/18/06 18:39

Rik wrote:

> 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,


Well, OK;

Already tried that first. With/without, single/double, doesn't seem to
matter.

Re-tried your suggestion and the result STILL results in ONLY ZERO in the
field. However, can a time function's result be put into a bigint field?

Bob

[Back to original message]