[RESOLVED] How can i make it check to see if something exists.

Pretty much i want it to connect to the databsase and see if an email already exists, and if so echo back sry this email is already in our system.

Do a select to find the email address. If you find it throw the error page.

can u provide a sample code, i keep trying but cant get it.

$sql = "select count(*) as count from YOURTABLE where YOURTABLEEMAILNAME = 'FORMEMAILNAME';

$result = mysql_query($sql);

$row = mysql_fetch_array($result);

if ($row['count'] > 0 ) {

REDIRECT TO ERROR PAGE

}

else {

REDIRECT TO PROPER PAGE

}

More or less.

thank yopu, i now know everything and can modifie it for my needs.