[PHP] Still error messages!!

[Radwan Aladdin]

Hello all..

This is the PHP code :

<?php

include("Config.php");

$link = mysql_connect("$user_hostname", "$user_username", "$user_password");
mysql_select_db("$user_database", $link);

$UserName = $_GET['UserName'];
$Password = $_GET['Password'];
$LogoutTime = date("U");

$query1 = "UPDATE accounts SET LogoutTime=$LogoutTime";
$query2 = "SELECT LoginTime,Distance,LessonNumber FROM accounts WHERE 
UserName='$UserName' AND Password='$Password'";
$query3 = "UPDATE accounts SET LessonNumber=LessonNumber + 1";
$result = mysql_query($query1) or die("Query error: " . mysql_error());


$RightLoginTime = 'LoginTime';
$Distance = 'Distance';
$LessonNumber = 'LessonNumber';
$LessonsTimeLimit = "30";

$query4 = "UPDATE accounts SET (Distance='" . $LogoutTime - $RightLoginTime . "') 
WHERE UserName=" . $UserName . " AND Password=" . $Password . ")";
$result2 = mysql_query($query4) or die("Query error: " . mysql_error());

if($Distance == $LessonsTimeLimit){
    $result3 = mysql_query($query3) or die("Query error: " . mysql_error());
}else{
    echo "Not yet!";
}

?>

And this is the mySQL structure :

# phpMyAdmin MySQL-Dump
# version 2.2.3
# http://phpwizard.net/phpMyAdmin/
# http://phpmyadmin.sourceforge.net/ (download page)
#
# Host: localhost
# Generation Time: Jan 28, 2004 at 08:27 PM
# Server version: 3.23.47
# PHP Version: 4.1.1
# Database : `elearning`
# --------------------------------------------------------

#
# Table structure for table `accounts`
#

CREATE TABLE accounts (
  UserName varchar(50) NOT NULL default '',
  Password varchar(50) NOT NULL default '',
  SecurityQuestion varchar(50) NOT NULL default '',
  SecurityAnswer varchar(50) NOT NULL default '',
  CourseTitle varchar(50) NOT NULL default '',
  CourseLanguage varchar(50) NOT NULL default '',
  FirstName varchar(50) NOT NULL default '',
  LastName varchar(50) NOT NULL default '',
  BirthDay varchar(50) NOT NULL default '',
  BirthMonth varchar(50) NOT NULL default '',
  BirthYear varchar(50) NOT NULL default '',
  Gender varchar(50) NOT NULL default '',
  Language varchar(50) NOT NULL default '',
  Country varchar(50) NOT NULL default '',
  StateOrCity varchar(50) NOT NULL default '',
  ZIPPostalCode varchar(50) NOT NULL default '',
  Occupation varchar(50) NOT NULL default '',
  Email varchar(50) NOT NULL default '',
  Phone varchar(50) NOT NULL default '',
  Mobile varchar(50) NOT NULL default '',
  Serial varchar(50) NOT NULL default '',
  Activation varchar(50) NOT NULL default '',
  Random varchar(101) NOT NULL default '',
  Adjective varchar(50) NOT NULL default '',
  LessonNumber varchar(50) NOT NULL default '',
  LoginTime varchar(200) NOT NULL default '',
  LogoutTime varchar(200) NOT NULL default '',
  Distance varchar(50) NOT NULL default '',
  UNIQUE KEY UserName (UserName)
) TYPE=MyISAM;

#
# Dumping data for table `accounts`
#


So where are the errors?

Waiting your help please..

Regards..