Answered by : terrible-tapir-3nc2zditw4iz

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

Source : https://stackoverflow.com/questions/5320395/codeigniter-order-by-on-a-query | Last Update : Thu, 11 Jun 20

Answered by : yawning-yak-6sm8jwtp7tcg

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

Source : https://stackoverflow.com/questions/5320395/how-to-add-an-order-by-clause-using-codeigniters-active-record-methods | Last Update : Sat, 30 Jan 21

Answered by : red-team

$this->db->order_by("UPPER(course_name)","desc");

Source : | Last Update : Wed, 30 Mar 22

Answered by : said-hr

$this->db->order_by('title', 'DESC');
// Produces: ORDER BY `title` DESC

Source : https://www.codeigniter.com/userguide3/database/query_builder.html | Last Update : Fri, 04 Mar 22