<?php
session_start();

//By Quackie, for Sindre :)

$user = mysql_real_escape_string($_POST['username']);
$pass = mysql_real_escape_string($_POST['username']);

$query = mysql_query("SELECT * FROM users WHERE username = '$user'");
$fetch = mysql_fetch_assoc($query);

if ($pass != $fetch['password'])
{
echo "wrong pass brah";
}
elseif ($pass == "" || $user == "")
{
echo "It appears all fields are blank!";
}
else
{
$_SESSION['name'] = $user; // Starts session
echo "Hello, ".$_SESSION['name'];
}

if($_SESSION['name'])
{
$session = $_SESSION['name'];
$query = mysql_query("SELECT * FROM users WHERE username = '$session'");
$fetch = mysql_fetch_assoc($query);
echo "You haz ".$fetch['coins']." coins";
}

?>