$conditions = array("`date_added` > " . "'" . $startDate . "'",
"`date_added` < " . "'" . $endDate . "'");
On Dec 17, 3:30 pm, Baz <[EMAIL PROTECTED]> wrote:
> Make sure debug is on and check the Query that is being written.
>
> I, personally, have never used the "BETWEEN" for MySQL. I usually have
> something like:
>
> $from = ....
> $to = ....
>
> $condition = array('date' => "date > $from and date < $to");
>
> But that's just me.
>
> On Dec 17, 2007 3:18 PM, Fabian <[EMAIL PROTECTED]> wrote:
>
>
>
> > Hi is it posible to define the $conditions inside a function instead
> > on the beginning of the controller. I have the following
>
> > <?php
> > class EventsController extends AppController {
> > var $conditions = array();
>
> > function encrypt() {
> > $conditions = array("date_added" => "BETWEEN 2007-11-01 AND
> > 2007-11-02");
> > $this->set('events',
> > $this->Event->findAll($this->conditions));
>
> > if (isset($this->namedArgs['date']))
> > {
> > echo $myParam1 = $this->namedArgs['date'];
> > }
>
> > ?>
>
> > I want to use the $this->namedArgs['date'] in the conditions variable,
> > but right now I just wrote the static code since I'm trying to make it
> > work, but when I run it the condition is ignored and it brings me all
> > the records regardless of date.
>
> > Is there a simpler way like in a find() where I can get records added
> > a certain date?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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
-~----------~----~----~----~------~----~------~--~---
