$username = $_POST['username'];
$password = $_POST['password'];



if(isset($_POST['submit'])){
    $login = mysql_query("SELECT * FROM users WHERE username='$username' AND password='$password' LIMIT 1");
    $login_result = mysql_num_rows($login);
    //login_validate();
}

echo $login_result;


function login_validate() {
    if ($login_result == 1) {
        session_start();
        session_regenerate_id(true);
        $_SESSION['username'] = $_POST['username'];
        header('Location: home.php');
    }
    else {
        header('Location: index.php');
        echo '<p class="error">Login incorrect.</p>';
    }
}