04-28-2010, 07:42 AM
[eluser]pickupman[/eluser]
Have you tried:
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();