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] <javascript:>
> MSN: [email protected] <javascript:>
> Móvil: +5493424663813
>
>
> 2012/8/21 MetZ <[email protected] <javascript:>>
>
>> 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]<javascript:>
>> .
>> To unsubscribe from this group, send email to
>> [email protected] <javascript:>.
>> 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.
