How to use this query to compare with array values

[eluser]Unknown[/eluser]
$query = $this->db->query("SELECT DISTINCT email FROM users, society_members AS A

WHERE users.user_id = society_members.user_id");

if ($query->result() == $emailv)


$emailv is in a for loop containing email values

[eluser]CroNiX[/eluser]
Single row

Code:

if ($query->row()->email == $emailv)

Or multiple rows

Code:

foreach($query->result() as $row)
{
  if ($row->email == $emailv)
  {
    //...
  }
}

[eluser]Unknown[/eluser]
Call to a member function row() on a non-object. I am getting this error on writing the above if stmt