msyql_query help please

[lukerodham]

Hey guys for some reason the code below, will insert into the data the information required even if there is the same email address already registered, have i done something wrong?

            $query = mysql_query("SELECT * FROM users WHERE email=$email");
            $count = mysql_num_rows($query);
            
            if($count==0){
                mysql_query("INSERT INTO users VALUES(NULL,'$firstname','$lastname','$email','$password','$day','$month','$year','$sex')") or die(mysql_error());
                echo "Well done. Passwords match";
            }
            else {
                echo "Please use another email as this one is already registered.";
            } 

[dragon_sa]

try this

 

$query = mysql_query("SELECT * FROM users WHERE email='$email'");

 

single quotes around $email

[revraz]

When something like that doesn't work, try putting your query in a variable, then echo the variable so you can see what is actually being passed.  Will help a lot in troubleshooting.