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- gt db- gt get  this- gt table name   return  query- gt 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

User · Answer

Just add the order by  clause to your code and modify it to look just like the one below     this- gt db- gt order by  name    asc     result    this- gt db- gt get  table     There you go

User · Answer

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- gt db- gt from  this- gt table name    this- gt db- gt order by  quot name quot    quot asc quot     query    this- gt db- gt get     return  query- gt result     CodeIgniter Documentation order by

User · Answer

Simple and easy    this- gt db- gt order by  name    asc     query    this- gt db- gt get  this- gt table name   return  query- gt result

User · Answer

Using this code to multiple order by in single query    this- gt db- gt from  this- gt table name    this- gt db- gt order by  column1 asc column2 desc     query    this- gt db- gt get     return  query- gt result

User · Answer

function getProductionGroupItems  itemId         this- gt db- gt select  quot   quot          this- gt db- gt where  quot id quot   itemId         this- gt db- gt or where  quot parent item id quot   itemId                     order by                      this- gt db- gt order by  quot id quot    quot asc quot           q  this- gt db- gt get  quot recipe products quot         if  q- gt num rows   gt 0            foreach  q- gt result   as  row                 data    row                      return  data             return false

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

Examples related to php

Examples related to codeigniter

Examples related to select

Examples related to activerecord

Examples related to sql-order-by