YES!!
You are totally awesome!
Looks like it returns the correct users now. I will do some testing..
Thanks alot!
Regards!
-Tom
kl. 20:25:11 UTC+2 tirsdag 21. august 2012 skrev MetZ følgende:
>
> Hi..
>
> No,, that one also return empty array :(
>
> Thanks anyway! any other suggestion?
>
> -Tom
>
>
> kl. 20:19:16 UTC+2 tirsdag 21. august 2012 skrev Mancho Murgan følgende:
>>
>> Try with this sintax:
>>
>> $users = $this->User->find('all', array('conditions' =>
>> array('User.last_seen BETWEEN NOW() AND NOW() -INTERVAL 1 DAY'),
>> 'recursive' => -2);
>>
>> --
>> Murgan, Alexis Germán
>> Desarrollador & Diseñador
>> Web: german.murgan.com.ar
>> Email: [email protected]
>> MSN: [email protected]
>> Móvil: +5493424663813
>>
>>
>> 2012/8/21 MetZ <[email protected]>
>>
>>> How can I find the Users that are "last_seen" the last 24hours?
>>>
>>> [User][last_seen] => 2012-08-18 08:10:31
>>>
>>> last_seen is updated each time a logged in user browse the website with
>>> current timestamp
>>>
>>> This is what I have tried this far:
>>>
>>> $users = $this->User->find('all',array('conditions'=>array('User.last_seen
>>> >' =>'BETWEEN NOW() AND NOW()- INTERVAL 24 HOURS'),'recursive'=>-2));
>>>
>>> But my array is coming back empty.
>>>
>>> Suggestions??
>>>
>>> As always!! You are awesome! Thanks for your time!
>>>
>>> -Tom
>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "CakePHP" group.
>>> To post to this group, send email to [email protected].
>>> To unsubscribe from this group, send email to
>>> [email protected].
>>> Visit this group at http://groups.google.com/group/cake-php?hl=en-US.
>>>
>>>
>>>
>>
>>
--
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
Visit this group at http://groups.google.com/group/cake-php?hl=en-US.