[FIXED] CakePHP - select from database with condition

Issue

I have this selector:

$this->Table->find('list',array('contain'=>false,'conditions'=>array('status'=>1,'unit_id'=>null,'country_id'=>$countryId,'eday'=>$eday),'fields'=>'id'));

And this works perfect. But now i need to have another one i cant find how to do this ;)

I need to select all records from Table but with condition:

'eday'>=$eday AND 'eday'<$eday+7 

Its this posibble in easy way? Maybe this is stupid question but i dont have exp in PHP ;)

Solution

In cakephp the equivalent for and condition is
Example: column1 = 'value' AND column2 = 'value'

'AND' => array(
    'column1' => 'value',
    'column2' => 'value'
)

So your query builder would be like this

$this->Table->find('list',array(
    'contain' => false,
    'conditions' => array(
        'status' => 1,
        'unit_id' => null,
        'country_id' => $country,
        'AND' => array(
            'eday >=' => $eday,
            'eday <' => ($eday+7)
        )
    ),
    'fields'=>'id'
));

Answered By - Beginner