As the question states, how can I order by first second and third column ascending.
At present I use
$this->db->select('id, company, first_name, last_name, landline_tel, mobile_tel, fax_tel, email');
$query = $this->db->get('clients');
but this only orders by the company column and I would like to order by the last_name column as a second sort.