使用Mysqli的两个查询

Question

Problem:

Trying to run two MySQLi queries against the database but results always into a failure message.

Code (PHP):

// Checks whether submit button has been pressed
if (isset($_POST['submit']))
{
    // Gets values from form fields
    $email      = mysql_real_escape_string(stripslashes($_POST['email']));
    $password   = mysql_real_escape_string(stripslashes($_POST['password']));

    // Selects e-mail in database
    $query  = "SELECT * FROM userlogin WHERE email = '{$email}'";
    $result = mysqli_query($link, $query) or die('Error  [' . mysqli_error($link) . ']');

    // Checks whether e-mail exist
    if (mysqli_num_rows($result) != 0)
    {
            // Register new user
            $query = "INSERT INTO 
                            userlogin 
                        (username, password, email, regdate)
                            VALUES
                        ('James','{$password}', '{$email}', NOW())
            ";

            // Submit query to database
            $result = mysqli_query($link, $query) or die('Error  [' . mysqli_error($link) . ']');

            // Return success message
            header('Location: index.php?notification=success');
    }
    else
    {
        // Return failure message
        header('Location: index.php?notification=fail');
    }
}

What am I missing? Any advice is appreciated.

Answer 1

Shouldn't this

mysqli_num_rows($result) != 0

be

mysqli_num_rows($result) == 0