Codeigniter-对从MySQL检索到的值进行排序

干得好。。。

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

在中阅读更多 codeigniter documentation for active record class .

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

举个例子:

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