SQL not working

[iceraider]

I need to see if this email exists in my database. For some reason its not working???

 $resulted = mysql_query("SELECT email FROM members WHERE email='$email'",$db);
 if($resulted) {
   $a = mysql_fetch_row($resulted);
   if($a) {
      error("That email has already been registered");
   }
 }

[kevinsequeira]

mysql_connect($username,$password,$db);
$query = "SELECT email FROM members WHERE email='$email' ";
$result = mysql_query($query);
if(mysql_error()){
print (mysql_error()."<BR>");
print ($query."<BR>");
exit;
}
if(mysql_num_rows($result) > 0){
print($email." already exists");
}else{
// new mail processing
}

Try this out, if there is an error in the SQL it will display it, lemme know if it works

[kevinsequeira]

my mistake .. replace

mysql_connect($username,$password,$db);

with

mysql_connect($SERVER,$USER,$PASSWORD);
mysql_select_db($D😎;