$this->Activity->bindModel(array(
'hasOne' => array(
'TotalUsers' => array(
'className' => 'User',
'fields' => 'COUNT(TotalUsers.id) AS num_users'
)
)
);
$popularActivities = $this->Activity->find('all', array(
'conditions' => '1=1 GROUP BY Activity.id HAVING num_users > 0',
'order' => 'num_users DESC',
'limit' => 10,
'recursive' => 0
));
Will find the 10 most popular activites, most popular first.
Activities with no users are not returned.
Also, look into counterCache - it will make this much easier for you.
On May 20, 2:26 pm, Dan Soendergaard <[EMAIL PROTECTED]> wrote:
> Hi,
>
> My app contains a User model and an Activity model. A User belongsTo
> an Activity. The foreign key is activity_id.
> Now, I want to make a list of popular activities where popularity is
> measured by how many users are signed up for it. I'm not sure how to
> do this. Can I use $this->Activity->find()? If yes, how do I tell it
> that I want the count of users for each activity?
>
> Thanks in advance :)
>
> Sincerely,
> Dan
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
