figured it out thank you all
$questions = $this->Question->find('all', array('conditions' => array
('AND' => array('OR' => array('Question.tip' => 'yes'),'NOT'=> array
('Question.active' => '0')))));
On Aug 24, 7:15 am, cakephp_rocks <[email protected]> wrote:
> how to do this complex find with this table
>
> id
> question
> answer
> tip= 0/1 default is 0
> active = 0/1 default is 0
>
> so what i want to do is if its tip= 1 it should show tip or if its
> tip = 0 its show the question
>
> it should not show if its active = 0
>
> 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
-~----------~----~----~----~------~----~------~--~---
