Ordering DB results by date

[eluser]Yash[/eluser]
[url="http://ellislab.com/codeigniter/user-guide/database/active_record.html#select"]USER GUIDE[/url]

$this->db->order_by();

Lets you set an ORDER BY clause. The first parameter contains the name of the column you would like to order by. The second parameter lets you set the direction of the result. Options are asc or desc, or random.
$this->db->order_by("title", "desc");

// Produces: ORDER BY title DESC