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

by

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

More Related Contents:

  1. How to create Codeigniter batch insert array
  2. Grouping WHERE clauses in Codeigniter
  3. How to select rows where column value IS NOT NULL using CodeIgniter’s ActiveRecord?
  4. Escaping SQL queries in Codeigniter
  5. Count array by parse value of array
  6. base_url() and site_url() not working in live server [closed]
  7. Fatal Error: Allowed Memory Size of 134217728 Bytes Exhausted (CodeIgniter + XML-RPC)
  8. How should I choose an authentication library for CodeIgniter? [closed]
  9. base_url() function not working in codeigniter
  10. Codeigniter displays a blank page instead of error messages
  11. Accessing Class Properties with Spaces
  12. Multiple image upload with CodeIgniter
  13. Selecting multiple array elements
  14. Extending The Controller Class in CodeIgniter
  15. How to integrate WordPress template with CodeIgniter
  16. Namespace in PHP CodeIgniter Framework
  17. SELECT COUNT() vs mysql_num_rows();
  18. Select from mysql table WHERE field=’$array’?
  19. Codeigniter Sessions not working after migration
  20. CodeIgniter activerecord, retrieve last insert id?
  21. Codeigniter echoing [::1] instead of localhost
  22. Advantages / Disadvantages of pconnect option in CodeIgniter
  23. MySQL ORDER BY IN()
  24. CodeIgniter: A Class/Library to help get meta tags from a web page?
  25. Routing controllers in subfolders using CodeIgniter
  26. Codeigniter: Best way to structure partial views
  27. Codeigniter: fatal error call to undefined function mysqli_init()
  28. php copying array elements by value, not by reference
  29. Reports in Codeigniter
  30. How can I have CodeIgniter load specific pages using SSL?

Leave a Comment