mysql_fetch_row() in CodeIgniter

[eluser]jedd[/eluser]
[quote author="punchi" date="1260745667"]

Code:

foreach ($query->result_array() as $row)
{
    echo $row[0]; //tried $row['0'];
    echo $row[2]; //tried $row['2'];
}

[/quote]

Either a) reassess why you want to be able to this (as you might be happier to just use the normal array walking functions of PHP - like everyone else does), or b) in the model you can massage your return data to look like this (I really do prefer option (a))).

For example:

Code:

$rows = $query->result_array();
$retdata = array();
foreach ($rows as $row)
    $retdata[] = $row;
return $retdata;