PHP

codeigniter order by

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

CodeIgniter get_where order_by

$query = $this->db->order_by('birth_date', 'ASC')->get_where($this->tbl_name, $where);

codeigniter order_by

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

HOE TO USE ORDER BY IN codeigniter query

$this->db->order_by('RegisteredUserID','ASC')