Perfect, thanks so much!
On Wed, Oct 15, 2008 at 3:54 PM, Chez17 <[EMAIL PROTECTED]> wrote:
>
> 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
-~----------~----~----~----~------~----~------~--~---
