Executing DB::query

[ssk]

How can I execute a SQL query using DB::query?

This is a function in a controller:

function abc() {
$result = DB::query("SELECT * FROM table WHERE id>1");
return $result;
}

But I get:
ErrorException [ Warning ]: Invalid argument supplied for foreach()

[Daniel]

You should use

$result = DB::query("SELECT * FROM table WHERE id>1")->execute();

foreach($result as $item){
...
}

More info: http://fuelphp.com/docs/classes/database/usage.html