Query problems, is this possible??

[miles_rich]

i need to check a mysql database with php for a number of things, and if they all match up then display an error msg that that entry is already in the database.

i need to check whether a firstname, lastname and a telephone number are the same as an entry made on a web form, to stop the entry from being entered again, but it will let the entry be entered if it is the same telephone number but with a different name.

I can do everything apart from the checking multiple fields.

Any ideas on how to do this??

any example code would be great!!

[Quevas]

After database connection:

$sqlquery=SELECT * FROM yourTable WHERE name='$enteredName' AND lastname='$enteredLastname' AND
telephone='$enteredTelephone'

$res=mysql_query($sqlquery,$db);

$control=mysql_num_rows($res);

if($control)
{
echo "<script>window.alert('The record already exist!')</script>";
exit;
}

If not control then insert the new record...

This is only an example, naturally...