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 cake-php@googlegroups.com.
To unsubscribe from this group, send email to 
cake-php+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en-US.


Reply via email to