SQL

codeigniter query builder order by

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

HOE TO USE ORDER BY IN codeigniter query

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

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