i appologize i forgot to add the rest: if($checkEmail != "0"){ echo("<center><font color=\"#990000\">The email address has already been registerd with an account.</font></center>"); include("../includes/footer.php"); exit; } Thanx! Brad Ciszewski www.BradTechnologies.com Web Services "Brad Ciszewski" <bradcis@xxxxxxxxxxx> wrote in message news:20041219193845.39315.qmail@xxxxxxxxxxxxxxx > Hi everyone, I am having some issues with this script. I am making a form > which registers a user. However, i want to check that the email address isnt > already registered in the database. Below is the syntax which i used. Please > help me figure out what I did wrong. > > *connects to database* > > $email = $_POST["email"]; > > $checkEmail = mysql_query("SELECT * > FROM memberInformation > WHERE email = '$email'"); > > Thanks in advance!! > > Brad Ciszewski > www.BradTechnologies.com Web Services -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php