$this->db->orderby ?

[eluser]outtolunch[/eluser]
Thanks a lot for your help, thats what I was looking for.

Just I've got one more problem with pagination.

I use CI pagination class.

my data model looks like that at the moment:

$query = "SELECT * FROM companies WHERE area='$area' AND category='$category' AND status='active' ORDER BY sub_area='$sub_area' DESC, sub_area DESC";
$companies = $this->db->query($query);

return $companies;

If I add into SQL query the LIMIT $limit, $offset I start getting some syntax errors about the ','.

Is there a way to use $this->db->limit($limit, $offset); ?

Lets say use $this->db->query($query), then $this->db->limit($limit, $offset) and return mysql result.