title: MYSQL query statement for empty field
body: <p>My database contains data as per the sample below. I would like to select the red highlighted row. Tried this query but doesn't display the row that I wanted. Any help is very much appreciated.</p>
  
  <pre><code>&lt;?php
  
  mysql_connect("localhost", "xxxxx", "xxxxx") or
  die("Could not connect: " . mysql_error());
  mysql_select_db("xxxxx");
  
  $result = mysql_query("SELECT * FROM tablename");
  
  $row = mysql_fetch_array($result);
  
  if($row['imageurl'] == 0){
  echo $row['email'];
  }
  
  mysql_free_result($result);
  
  ?&gt;
  </code></pre>
  
  <p>Code above will return 'abc@abc.com'.</p>
  
  <p><img src="https://i.stack.imgur.com/KWqCW.jpg" alt="enter image description here"></p>