how to use order by codeigniter

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

Agreed, you should indeed call the query methods in the correct order. Makes for better reading of the constructed query.

But that had nothing to do with his problem. The problem is in his result parser.