Codeigniter - sort retrieved values from MySQL

Question

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

Thanks.

I have no idea what codeigniter is, but "order by id desc"? :) — falstro
– falstro, Commented Aug 20, 2010 at 10:35
Yeah, this should really be done in the query, not afterwards. — Pekka
– Pekka, Commented Aug 20, 2010 at 10:39

vikmalhotra · Accepted Answer · 2010-08-20 10:44:22Z

7

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.

answered Aug 20, 2010 at 10:44

vikmalhotra

10.1k20 gold badges100 silver badges138 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

So Over It · Accepted Answer · 2010-08-21 05:22:37Z

5

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();

answered Aug 21, 2010 at 5:22

So Over It

3,6883 gold badges37 silver badges46 bronze badges

Comments

mstafkmx · Accepted Answer · 2013-03-01 08:23:15Z

2

An exemple:

$query = $this->db->order_by("id", "desc")->get('table');
if($query->num_rows>0){
   foreach ($query->result() as $row){
      $names[] = $row->name;
   }
   return $names;
}

edited Mar 1, 2013 at 8:23

answered Feb 26, 2013 at 3:27

mstafkmx

4295 silver badges17 bronze badges

Collectives™ on Stack Overflow

Codeigniter - sort retrieved values from MySQL

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related