You would need to use joins here: http://book.cakephp.org/view/1047/Joining-tables
Looks complex at first, but actually isn't. And once you've mastered it you'll use it in preference to plain old SQL where normal finds won't cut it. Jeremy Burns Class Outfit http://www.classoutfit.com On 2 Nov 2011, at 17:15, nastya wrote: > Hello > > Could you please help me with a small issue? > > There are Posts that are active. Posts can have comments. Comments can > be active or not. How to get only those active Posts that have active > Comments? > > $this->Post->find('all', array( > 'conditions' => array('Post.active'=>1), > 'contain' => array( > 'Comment' => array('conditions' => array('Comment.active' => > 1)) > ) > )); > > This query will get all active posts even if they don't have active > comments... How to get only those with active comments? > > Thank you. > > -- > Our newest site for the community: CakePHP Video Tutorials > http://tv.cakephp.org > Check out the new CakePHP Questions site http://ask.cakephp.org and help > others with their CakePHP related questions. > > > To unsubscribe from this group, send email to > cake-php+unsubscr...@googlegroups.com For more options, visit this group at > http://groups.google.com/group/cake-php -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php