Checking equality syntax

[todds]

Hello
I am having difficulties, I am modifing a mailling list script to incorporate a checker to see if a user is already signed up to be on the list.
Anyway, in the mySQL db email addresses are stored as email, and are the same thing in the script. I would like to compare what the user inputs to what is already in the database.
I just don't know the syntax to accomplish this.

would it be something like this:

if ($email == $email){
print "This email appears to already be subscribed to the list."
}

Any help is appreciated.
Todd

[ugasucks]

hmm... sounds like you need to search the database for what is already there. to do that, you'd :

$connection = mysql_connect($host, $user, $pass);
mysql_select_db($mydatabase, $connection);

Now you need to make a SQL query. It sounds like it should be something like:

$email -- this is the email addy to check for

$query = "SELECT * FROM ".$db." WHERE email = '$email'";
$result = mysql_query( $query, $connection );

where $db is the DB that contains the stored addresses.

$inDatabaseAlready = mysql_num_rows( $result );

thus, if (!($inDatabaseAlready)) you should add the email address to the list.

hope this helps.

[todds]

thank you much uga.