Code: Select all
<?php
if (isset($_POST['submit']))
{
$email=$_POST['email'];
$password=$_POST['password'];
$email=strip_tags($email);
$password=strip_tags($password);
$password=md5($password);
$query = "SELECT email,password FROM players WHERE email='$email' AND password='$password'";
$result = mysql_query($query) or die("Could not query players");
$result2 = mysql_fetch_array($result);
if ($result2)
{
$sql = "UPDATE players SET last_login=CURDATE() SET online='1' WHERE email='$email'"; <--- This is not working
session_start();
$_SESSION['email']=$email;
header('Location: http://darkorder.rockywoodinc.com/game.php');
}
else
{
echo "<big>Wrong username or password.<A href='index.php'>Try Again</a></big>";
exit;
}
}
?>