how to use order by codeigniter

The order in which you call the methods does not matter. Query Builder sorts them out for you and will place everything in the correct order.

This is your problem

PHP Code:

$returnArray[$item->$key] = strtolower($value) == 'obj' ? $item : $item->$value; 


You are overwriting values in the array because the same column is returned more than once. So this way only the last value is returned.

This is like teaching someone a bad habit, try running that query in raw MySQL.

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )