DB Question

[eluser]Unknown[/eluser]
Hi,

How to get the results of a Query sorted in any order?Thanks!

___________________
<a href="http://www.echipamenteortopedice.ro">echipamenteortopedice.ro</a>

[eluser]CroNiX[/eluser]

Code:

$users = $this->db
  ->order_by('users.lname', 'ASC')
  ->get('users')
  ->result_array();

Code:

echo $this->db->last_query();
//produces
SELECT * FROM users ORDER BY users.lname ASC