On 9/20/2009 7:33 PM, Dave Maharaj :: WidePixels.com wrote:
> How can this be done.
> Users create Posts...now I want to get a list of top 10 Posters (users
> who have made the most posts).
> How would you do the conditions => array() for this? How can I get a
> list of Users when the User.id is unknown or all of them?
>
Assuming that Post BelongsTo Users and that you have a user_id field in
the posts table, your posts model will have this method:
function top_posters($count = 10){
return $this->find('all', array('fields' =>
array('Post.user_id', 'COUNT(Post.user_id) AS posts_count'),
'conditions' => array('Post.user_id NOT' => ''),
'group' => array('Post.user_id'),
'order' => array('posts_count DESC'),
'limit' => $count));
}
This method will return an array containing user ids and posts count
order by post count, but you already figured that out.
HTH,
Alex.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
