counting rows with mysql and php

[whitep8]

Hi all,

Im at a loss here. There are definitly a lot of emails repeated in the table, but it just wont echo out anything.

all help is appreciated

<?php
session_start();
include "connect.php";
        $name = $_SESSION['name'];
        $email = $_SESSION['email'];
        $nationality = $_SESSION['country'];
$query = "SELECT * FROM tbl_beta WHERE email =' $email'" or die(mysql_error());
$result = mysql_query($query);
$unique = mysql_num_rows($result);
if($unique > 1){
    echo "Sorry, That email has already been registered in out database.  Please contact support at ";
    exit();
    }else{
    $SQL = "INSERT INTO tbl_beta (name, email, nationality) VALUES ('$name', '$email', '$nationality')";
        $result = mysql_db_query($db,$SQL,$cid);
    echo "Thanks for registering " . $name;
    echo "<br>We will be in touch shortly."; 
    $_SESSION['betaemail'] = $email;
    include "mail.php";
    }
    ?>
 

[Markus]

I imagine that space before $email is causing your problem (line 7).