$this->db->from($this->table_name); $this->db->order_by("column1 asc,column2 desc"); $query = $this->db->get(); return $query->result();