CakePHP Count syntax

Question

I am writing an app in CakePHP and need to get a count of posts for an image. its a one (image) to many (comments) link.

I have tried the following but it doesnt work as it cant find the table? I know I have managed to do this with just SQL queries in previous applications.

This is the code

$data = $this->Image->find('all', array(
'fields' => array('COUNT(Comment.comment_id) AS total', 'Image.*'),
'group' => array('Image.logo_id')
));

basically I want to output the image details and then a comment count which is associated to the image.

Hope someone can help.

Thanks.

Try setting debug level to 2 in the config file and see what happens. CakePHP should stop caching the structure of your database. — Mike
– Mike, Commented Sep 28, 2011 at 20:25
@Mike I have been able to do it the other way around as in count from the Comment table. Debug is set to L2, but it says it cant find the table Comment. — Tony
– Tony, Commented Sep 29, 2011 at 10:34
@deizel, yes I have seen that, but didnt think it was a brilliant solution... — Tony
– Tony, Commented Sep 29, 2011 at 10:35
How so? It's built specifically for this purpose. Admittedly it can't handle complex joins, but this is quite a simple requirement and should solve your problem nicely. — Ross
– Ross, Commented Sep 30, 2011 at 8:34

Tony · Accepted Answer · 2011-09-30 16:27:23Z

1

counterCache seems to be the answer, thanks guys!

answered Sep 30, 2011 at 16:27

Tony

8252 gold badges9 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

JJJ Over a year ago

Please mark the answer as accepted so that this question doesn't show up in the unanswered questions list.

Collectives™ on Stack Overflow

CakePHP Count syntax

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related