<?php

Class category extends CI_Model {

    function loadCategories() {
        $this->db->select('c.id, c.name, count(p.cat_id) cnt');
        $this->db->from('categories c');
        $this->db->join('post p', 'c.id=p.cat_id', 'LEFT');
        $this->db->group_by('c.name');
        $this->db->order_by('cnt','DESC');
        $query = $this->db->get();
        return $query->result();
    }

}