How can i get single value without foreach

[eluser]sophistry[/eluser]
a refinement on Doosje's suggestion (which is good) is to also use the LIMIT parameter in your query.

check the db docs, i think it is the second param you can send with a $this->db->get() method. that way you only get one record.