A problem using if function

[npsari]

I have a table called blocked

in which, i store many Emails which are blocked

 

I want to use an if function, which states if the user is blocked or not

 

So, the user submits his Email from a Form field called Email

 

I did...

 

$BlockedEmail=$r[Emails]; ///Colomb name in database

 

if ($Email=='??'){

print "Sorry, your Email has been blocked"

}else{

print "Welcome";

 

In the place where i put ?? i dont know what to do

 

I want to say, if the Email is any of the blocked Emails in the database, then, print Sorry

[trq]

<?php

  $email = mysql_real_escape_string($_POST['email']);
  if ($result = mysql_query("SELECT email FROM blocked WHERE email = '$email'")) {
    if (mysql_num_rows($result)) {
      echo "Sorry, you are blocked";
    }
  }

?>