How to add an ORDER BY clause using CodeIgniter's Active Record methods?

PhpCodeigniterSelectActiverecordSql Order-By

Php Problem Overview

I have a very small script to get all records from a database table, the code is below.

$query = $this->db->get($this->table_name);
return $query->result();

Using this syntax, how would I add a ORDER BY 'name' clause to my select query?

I get errors every time I stick the order by bit on the end.

Php Solutions

Solution 1 - Php

I believe the get() function immediately runs the select query and does not accept ORDER BY conditions as parameters. I think you'll need to separately declare the conditions, then run the query. Give this a try:

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

CodeIgniter Documentation order_by()

Solution 2 - Php

Using this code to multiple order by in single query.

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

Solution 3 - Php

Simple and easy:

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

Solution 4 - Php

Just add the'order_by' clause to your code and modify it to look just like the one below.

$this->db->order_by('name', 'asc');
$result = $this->db->get($table);

There you go.

Solution 5 - Php

function getProductionGroupItems($itemId){
	 $this->db->select("*");
	 $this->db->where("id",$itemId);
	 $this->db->or_where("parent_item_id",$itemId);

    /*********** order by *********** */
	 $this->db->order_by("id", "asc");

	 $q=$this->db->get("recipe_products");
	 if($q->num_rows()>0){
		 foreach($q->result() as $row){
			 $data[]=$row;
		 }
		 return $data;
	 }
	return false;
}
Categories
Recommended Php Solutions
Recommended Codeigniter Solutions
Recommended Select Solutions
Recommended Activerecord Solutions
Recommended Sql Order-By Solutions

Previous Solution:

Proper way to get page content

Wordpress

Next Solution:

How to bring a subview to the front when you tap it?

Ios

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionCecilView Question on Stackoverflow
Solution 1 - PhpTed AveryView Answer on Stackoverflow
Solution 2 - PhpNaresh KumarView Answer on Stackoverflow
Solution 3 - PhpVBMaliView Answer on Stackoverflow
Solution 4 - PhpObi Dennis ChizoluView Answer on Stackoverflow
Solution 5 - PhpvijayabalanView Answer on Stackoverflow