Duplication Problem???

[obrienkev]

Hi again,

Please could you help me here.
I have a web interface that allows the user to enter their name and email into a database.
How do I prevent multiple entries with the same details???

Thanks very much.

Kevin.

[Yamakazi]

Pseudo code:

$query = "select id from news where Name = '$Name' or Mail = '$Mail'";

$resulSet = mysql_query($query);

if(mysql_num_rows($resulSet)>0){
 echo "Info allready in the DB";
}else{
//do insert
}

Edit: Typo's

[obrienkev]

Thanks for that..This is what I have now.

mysql_select_db('news');

$query = "select name from news where email = '$email'";
$result = mysql_query($query);
if(mysql_num_rows($result)>0)
{
echo "Info already in the DB";
}
else
{
$query = "insert into subscribers values
('".$name."', '".$email."')";
$result = mysql_query($query);
}
if ($result)
echo 'Congratulations. You have subscribed to our newsletter.';
else
echo 'You have already subscribed to the newsletter.';

Could you please point out any errors.

Thanks very much,

Kevin.