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

Question

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.

Answer 1

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

Answer 2

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