[RESOLVED] No duplicate entries

[homer09001]

i have a user database how can i make it so that when someone registers it doesnt enter the info in the database if the e-mail address or username exists?

would it be a case of getting php to

SELECT * FROM $table WHERE user=$username AND email=$EMAIL

?

[void_function]

Yeah, but then use OR not AND, between two where clauses.

[homer09001]

thans but ive soled the probem:

$sql = "SELECT COUNT(*) FROM $table3 WHERE username='$Name'";
$result=mysql_query($sql); 
$num=@mysql_fetch_row($result); 
$return = $num[0];

$sql1 = "SELECT COUNT(*) FROM $table3 WHERE email='$email'";
$result1=mysql_query($sql1); 
$num1=@mysql_fetch_row($result1); 
$return1 = $num1[0];



if($return >= "1")
{
echo "Sorry That Username Already Exists";
exit();
}
elseif($return1 >= "1")
{
echo "Sorry It Appears That The Email Address You Entered Has Already Been Registered!";
exit();
}