Codeigniter - sort retrieved values from MySQL

Question

Hi,

Is it possible to sort the values retrieved from MySQL, in say descending id?

Thanks.

Answer 1

Here you go...

$this->db->select("*");
$this->db->from("table");
$this->db->order_by("id", "desc");
$this->db->get();

Read more over in codeigniter documentation for active record class.

Answer 2

As ShiVik suggested, you can do this via the Active Record class quite easily. Also note that you can chain your queries together if you are using PHP 5+:

$this->db->select('*')->from('table')->order_by('id', 'desc');
$query = $this->db->get();