Selecting category details and products linked with the same category.

[eluser]Bigil Michael[/eluser]

function select_fleets($limit, $pgoffset)
{
$this->db->limit($limit, $pgoffset);
$this->db->order_by("category_name","ASC");
$this->db->select('car_category.category_name, car_category.category_id, car_category.details, car_category.photo');
$this->db->from('car_category');
$this->db->join('cars', 'cars.category_id = car_category.category_id');
$result_product = $this->db->get();
return $this->db->get('car_category')->result_array();
}

here limit and order_by is not working can anyone help me??????????

thanks in advance