Answers for "codeigniter orderby query"

codeigniter order by

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

order by in codeigniter query builder

$this->db->order_by('RegisteredUserID','ASC')
// Produces: ORDER BY `RegisteredUserID` ASC

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