Untitled

<html>
<head></head>
<body>


<?php

$host="localhost"; // Host name
$username="test"; // Mysql username
$password="pocakaj"; // Mysql password
$db_name="game"; // Database name
$tbl_name="game"; // Table name
mysql_connect($host, $username, $password, $db_name);
mysql_select_db($db_name);
$myusername=$_POST['myusername'];
$mypassword=$_POST['mypassword'];
$online=$_POST['online'];
$query="SELECT password, username FROM $tbl_name WHERE username='$myusername' AND password='$mypassword' ";
$q=mysql_query($query) or die(mysql_error());
$row=mysql_fetch_assoc($q);

    if($row['password'] != $mypassword) {

		mysql_query("UPDATE game SET online = '0' WHERE username = 'myusername' AND password = 'mypassword'");
		echo "<SCRIPT language='JavaScript'>alert('Uporabniško ime ali geslo ni bilo pravilno. Preusmerjen boš nazaj.');</SCRIPT>";
                echo "<meta HTTP-EQUIV='REFRESH' content='0; url=login.php'>";
	}
	else
	{
		$_SESSION['myusername'] = $myusername['myusername'];
		$_SESSION['mypassword'] = $mypassword['mypassword'];
		mysql_query("UPDATE game SET online = '1' WHERE username = '$myusername' AND password = '$mypassword'");
        echo "<meta HTTP-EQUIV='REFRESH' content='0; url=index.php'>";


	    }
?>
</body>
</html>