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(
'conditions' => array(
'last_seen >' => date('Y-m-d H:i:s', strtotime('-1 day'))
)
));
Is a simpler query (and it's just an example - you can build the date
condition any way you like) - unless you have data such that it's possible
to be seen in the future (?) you don't need between.
AD
On Friday, 24 August 2012 18:20:40 UTC+2, Arafat wrote:
>
> I think this will help you
>
>
> http://arafats.info/cakephp-date-comparison-or-cakephp-date-bewteen-on-database-data/
>
> Thanks
> Arafat
>
> On Tue, Aug 21, 2012 at 11:54 PM, MetZ <[email protected] <javascript:>>wrote:
>
>> 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.
>>
>>
>>
>
>
>
> --
> *Thanks & Regards.
>
> -----------------------------------------------------------------------------------------------------------------------------
> Yasir Arafat (Hasib)*
> *Deputy Project Manager, *Software Solutions
> Grameen Solutions
> Contact Information:
> **
> **
> Cell : +8801816 536 901, +880197 *333* 2 888
> Web: http://arafats.info
> <http://arafats.info>
>
>
--
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.
