active record database query using order_by

[eluser]blasto333[/eluser]
This Works

Code:

$modules=array();
$query = $this->db->query('SELECT * FROM modules ORDER BY `sort` asc');

foreach($query->result() as $row)
{
    $modules[]=$row->id;
}

This doesn't work (Fatal error: Call to undefined method CI_DB_mysql_driver::result() )

Code:

$modules=array();
$this->db->get('modules');
$query = $this->db->order_by("sort", "asc");

foreach($query->result() as $row)
{
    $modules[]=$row->id;
}
return $modules;

Any ideas? I am using CI 1.6.3

[eluser]xwero[/eluser]
The sql statement building methods have to come before the action method; get, update, insert, ...
Most sql statement building methods have no return.

If you want to build the query in the order of the sql statement than you have to write

Code:

$this->db->from('modules');
$this->db->order_by("sort", "asc");
$query = $this->db->get();

[eluser]blasto333[/eluser]
Ah, ok thanks!