I'm no expert but I think I maybe able to help. So lets assume you
have a php variable $lastWeek that has the date you want (7 days ago).
You create a find statement like this:
$result = $this->YourController->find('all', array('conditions' =>
array('Table.created >' => "$lastWeek")));
Make sure Table is the name of the table you want. You put the ">" or
what ever operator you want inside the quotes of the table name. I
think that should do it.
On Oct 15, 2:36 pm, Daehee <[EMAIL PROTECTED]> wrote:
> Hi,
>
> So I have a table with the "created" field. I am using query() in my
> model to select rows from this table, and I would like to create a SQL
> statement to only select up to 7 days previous of today. Please help
> with this the WHERE portion of this SQL statement... Thanks!
>
> Daehee
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
