Return database query as enumerated array

[eluser]thisischris[/eluser]
I can't seem to find anything online or in the documentation.

How can I get an enumerated arary? As in php's mysqli_fetch_row function.

Code:

$row = $query->row();

echo $row['0']; // ?

Thank you!