<?php
session_start();
include_once ("common/connect.php");

$email = $_POST ['email'];
$pass = $_POST ['pass'];

$query = "SELECT ID,email,password FROM users WHERE email = '$email' AND password = '$pass'";


if (!($mysql_rs = mysql_query($query, $conn)))
        die("WTF is wrong with the DB");

while ($row = mysql_fetch_array($mysql_rs, MYSQL_ASSOC)) {
    $user = $row["email"];
    $contra = $row["password"];
    $_SESSION["id"] = $row["ID"];
}

$id = $_SESSION["id"];
$query2 = "SELECT user_id, game_id FROM users_results WHERE user_id = 7 AND game_id = 48";

if (($user == $email) && ($contra == $pass)){
    if(mysql_num_rows($query2)){
        header("Location: user_results_table.php");
        exit;
    }else{
    header("Location: game_1.php");
    }
}else{
    die("you dont belong here");
}