Re: Containable get posts with active comments

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+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php