How can i get single value without foreach

[eluser]Doosje[/eluser]

Code:

$row = $query->row();
echo $row->a_field_name;