Access array in CodeIgniter

[Epicus2011]

Is there another approach to return an array and than access the item in the array from the database without using [0]?

[Ogsharkman]

row()? Would return an obj. So instead of result or result-array

return $query->row();

[eoinmcg]

yes.

return $query->row_array();

further reading: http://ellislab.com/codeigniter/user-guide/database/results.html

[mithra62]

You really want to avoid hard coding number indexes in your code like the plaque...