// obtaining login info
require("info.php");

// connecting to server
$connect = mysql_connect("$host","$user","$pass");
if (!$connect){
die('Could not connect to server: ' . mysql_error());
}

// selecting database

//mysql_select_db($database, $connect);

if (!mysql_select_db($database, $connect)){
die('Unable to select database: ' . mysql_error());
}

// obtaining user input

$username = mysql_real_escape_string($_POST["username"]);
$password = md5(mysql_real_escape_string($_POST["password"]));



// checking user input versus records

if (!mysql_query("SELECT * FROM users WHERE username = \"$username\" AND password = \"$password\"")){
die('Unable to select table : ' . mysql_error());
}



if (username != $username || password != $password){
echo("The username or password does not match, please try again");
}