Reading database data in a view

[eluser]K-Fella[/eluser]
If you only expect one row from the database then use:

Code:

$data['user'] = $query->row(); // using row() instead of result()

Then in your view you can call:

Code:

$user->id // $user->name, etc

No need for loops.