Re: I want to find records during last 24 hours

2012-08-25 Thread AD7six
Yasir, I'm getting a bit bored of these replies that have no content and just a link (to a 1 sentance "answer"). If it's not obvious the group is not public so there is no SEO value in doing that. Metz, why would you use between for such a query? $this->User->find('all', array( '

Re: I want to find records during last 24 hours

2012-08-21 Thread MetZ
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? > >

Re: I want to find records during last 24 hours

2012-08-21 Thread Mancho
Ok, try with this: $users = $this->User->find('all', array('conditions' => array('User.last_seen BETWEEN NOW() -INTERVAL 1 DAY AND NOW()'), 'recursive' => -2); I have doubt about INTERVAL sintax but this is the correct sintax for cakephp. -- Murgan, Alexis Germán Desarrollador & Diseñador Web: g

Re: I want to find records during last 24 hours

2012-08-21 Thread MetZ
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(

Re: I want to find records during last 24 hours

2012-08-21 Thread Mancho
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: ger...@murgan.com.ar MSN: ger...@murgan.com.ar Móv

I want to find records during last 24 hours

2012-08-21 Thread MetZ
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('U