Re: Help making a query to select all Posts which have lots of Comments

I made a typo in the 2nd paragraph. I meant:

What I'm trying to do is select only Posts which have 5 or more
comments using pagination.

On Feb 7, 3:22 pm, andrewperk <andrewp...@gmail.com> wrote:
> Hello, I have a Post model with each Post can have many Comments and
> each Comment belongs to a Post.
>
> What I'm trying to do is select only Posts which have 5 more comments
> using Pagination.
>
> I'm confused on how to construct this query and how to do it using
> Pagination. I know I need to get a count of how many comments each
> post has, but how with the paginator?
>
> Can anyone point me in the right direction, something like
> Post.comments > 5, this doesn't work obviously.
>
> $this->Post->recursive = 1;
>         $this->paginate = array(
>                 'conditions'=>array(
>                         'status'=>'published',
>                         'Post.comments > 5'
>                 ),
>                 'limit'=>10,
>                 'order'=>'published_on DESC'
>         );
> $this->set('posts', $this->paginate('Post'));
>
> Thanks.

--
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