I'm having trouble with my login form and I'm not quite sure why. The code is not passing the
PHP Code:
if($login_check 0){ 
or while loop and is going to the else statement instead. I even tried taking the password hashing out and putting a generic password into my database but it still says "No match in our records, try again".

Here's the php.
PHP Code:
if ($_POST['email']) {
//Connect to the database through include
include_once "scripts/connect_to_mysql.php";
$email $_POST['email'];
$email mysql_real_escape_string($email);
$password $_POST['password'];
$password $password;
// Make query and then register all database data 
$sql mysql_query("SELECT * FROM members WHERE email='$email' AND password='$password'"); 
$login_check mysql_num_rows($sql);
$login_check 0){ 
$row mysql_fetch_array($sql)){ 
// Get member ID into a session variable
$id $row["id"];   
$_SESSION['id'] = $id;
// Get member username into a session variable
$username $row['username'];   
$_SESSION['username'] = $username;
// Update last_log_date field for this member now
mysql_query("UPDATE members SET lastlogin=now() WHERE id='$id'"); 
// Print success message here if all went well then exit the script
header("location: member_profile.php?id=$id"); 
// close while
} else {
// Print login failure message to the user and link them back to your login page
print '<font color="red">No match in our records, try again </font><br />
    <a href="login2.php">Click here</a> to go back to the login page.'
// close if post

And here's is the form.
Please log in.
	<form action="login2.php" method="post">
	<input type="text" name="email" id="email" placeholder="Email"/><br />
    <input type="password" name="password" id="password" placeholder="Password"/><br />
    <input type="submit" value="Login" />