Kmspico Download | Official KMS Activator Website [New Version 2024] Fast and Easy Converter YouTube to MP3 Online KMSAuto Net Activator Download 2024 Immediate Byte Pro Neoprofit AI Blacksprut without borders. Discover new shopping opportunities here where each link is an entrance to a world ruled by anonymity and freedom.

Sort Query in Codeigniter

Hello Freinds, today i will tell you taht how to sort data from database table in codeigniter sort query.

The Orderby method allows you to sort the results of the query by a given column. If your column has 20 data, you can sort it in ASC or DESC order with the help of this query.

In the lower Query you can see that by using Orderby you can sort the data from 2 fields.

By DESC order

$this->db->from($this->table_name);
$this->db->order_by("id", "desc");
$query = $this->db->get();
return $query->result();

By ASC order

$this->db->from($this->table_name);
$this->db->order_by("id", "asc");
$query = $this->db->get();
return $query->result();

By DESC order With Where

$this->db->from($this->table_name);
$this->db->where("city", "delhi");
$this->db->order_by("id", "desc");
$query = $this->db->get();
return $query->result();

By ASC order With Where

$this->db->from($this->table_name);
$this->db->where("city", "delhi");
$this->db->order_by("id", "asv");
$query = $this->db->get();
return $query->result();