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.
