[PHP] The final script! but still some problems..

[Radwan Aladdin]

Hi all..

This is the final PHP code that I written.. but there i some problems.. not errors.. I 
said problems.. For example the Distance value is not updated correctly.. and the 
LessonNumber field also.. please help me fixing these problems :

<?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";
$result1 = mysql_query($query1) or die("Query error: " . mysql_error());
$query2 = "SELECT LoginTime,Distance,LessonNumber FROM accounts WHERE 
`UserName`='$UserName' AND 

`Password`='$Password'";
$result2 = mysql_query($query2) or die("Query error: " . mysql_error());
$row2 = mysql_fetch_row($result2);
$query3 = "UPDATE accounts SET LessonNumber=LessonNumber + 1";

$RightLoginTime = $row2["LoginTime"];
$Distance = $row2["Distance"];
$LessonNumber = $row2["LessonNumber"];
$LessonsTimeLimit = "30";


?> <pre> <?
echo $query1;
echo $query2;
echo $query3;
?> </pre> <?


$query4 = "UPDATE accounts SET Distance=" . ($LogoutTime - $RightLoginTime) . " WHERE 

UserName='$UserName' AND Password='$Password'";
$result4 = mysql_query($query4) or die("Query error: " . mysql_error());));

$query5 = "SELECT Distance FROM accounts";
$result5 = mysql_query($query5) or die("Query error: " . mysql_error());
$row3 = mysql_fetch_row($result5);
$UpdatedDistance = $row3["Distance"];

?> <pre> <?
echo $query4;
?> </pre> <?

if($Distance == $LessonsTimeLimit){
    $result3 = mysql_query($query3) or die("Query error: " . mysql_error());

}else{
    echo "Not yet!";
}

?>


I'm sure it is very easy for you.. I hope that..
Regards..