ORDER BY COUNT

#2
[eluser]pickupman[/eluser]
Have you tried:
Code:
$this->db->select('*, COUNT(category_id) as rows');
$this->db->from('posts');
$this->db->group_by('category_id');
$this->db->order_by('rows','DESC');
$query = $this->db->get();


Messages In This Thread
ORDER BY COUNT - by El Forum - 04-28-2010, 07:36 AM
ORDER BY COUNT - by El Forum - 04-28-2010, 07:42 AM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.