How NOT to use foreach when expecting only 1 record?

[eluser]Slowcheetah[/eluser]
I'm wondering if and how it's possible to NOT use foreach when expecting only one record as a result.

My current model code:

Code:

function get_user_id($username, $useremail)
    {
        $this->db->where('username', $username);
        $this->db->where('email', $useremail);
        $query = $this->db->get('accounts', 1);
        if ($query->num_rows() == 1)
        {
            foreach ($query->result() as $row)
            {
                return $row->id;
            }
        }
    }