Checking if username/email exist in MySQL database...

[nivlaC]

I want to take the values of the form then check any matches for the username and email fields throughout the table. And if it returns false, I'll print an error message. I want to have an error message for each one (username/email).

Thanks.

[bastien]

<?

//assume you can code the form

$sql = "select * from usertable where username='$user' and email='$email'";

$result=mysql_query($sql, $conn) or die ("Couldn't hit the dababase.");

echo "<table>";

if (mysql_num_rows($result)==0){
echo "There are no results";
}else{
while $row=mysql_fetch_array($result){
$user=$row["username"];
$email=$row["email"];

     echo "<tr><td>$user</td><td>$email</td<td>Error!</td></tr>";

}
echo "</table>";
}
?>

hth