Hi Everyone,
I am just trying to perform a simple query using cakephp. In the
conditions array I am trying to filter by dates. The results should be
all 'events' that will be today or greater (in other words, any date
in the future).
$this->Event->find('all',array( 'conditions' =>array
('event_category_id'=>$catId,'DATE(Event.event_date)'=>'getdate
()'),'order'=>array('Event.event_date ASC','Event.event_time
ASC') ) ) ;
That is what i have so far. The first condition is just to filter by
category. The part I need help with is 'DATE
(Event.event_date)'=>'getdate()'). There are no errors. So i guess its
kind of working. Also how can i adjust 'today' by 4 hours ?
Thanks!
--~--~---------~--~----~------------~-------~--~----~
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]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
