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

2012-02-07 Thread Andras Kende
Hello, You could do it easily with counterCache http://book.cakephp.org/1.3/view/1033/counterCache-Cache-your-count Andras Kende http://www.kende.com On Feb 7, 2012, at 5:22 PM, andrewperk wrote: > Hello, I have a Post model with each Post can have many Comments and > each Comment belongs to

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

2012-02-07 Thread andrewperk
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 wrote: > Hello, I have a Post model with each Post can have many Comments and > each Comment belongs to a Post. > > What I'm tryin

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

2012-02-07 Thread andrewperk
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