Selecting with a variable

[Azarath]

I am wanting to make a register page for a game I'm making, and was wanting to make it so that if an email was already used it would return "Email already in use", but insert the data if it wasnt already used.

<? };

if ($action == "submit") { 

$email = $_POST["email"];
$pass = $_POST["pass"];
$name = $_POST["name"];
$group = $_POST["group"];

include ("config.php");

$checkwebaddy = mysql_query("SELECT email FROM members WHERE email = $email");

echo "$email<br>";
echo "1 :: $checkwebaddy";

if (!$checkwebaddy) {

$query = "INSERT INTO members VALUES ('$id','$email','$pass','$name','$group')";
$result = mysql_db_query("web13_tonguewars", $query);

echo "Welcome to Tongue Wars";

} else {

echo "Email already in use. Please enter a different email address.";

};

}; ?>

As you can see, I have no idea where to start trying to do this...any help would be appreciated.

[planetsim]

Take a look at [man]mysql_num_rows[/man] it will tell you how many rows are returned from the Query. Also some advice do some validation on your data, do a search on SQL Injections here you will more than likely find a some sample code on how to prevent it.