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

[Radwan Aladdin]

So what is the problem?
  ----- Original Message ----- 
  From: Radwan Aladdin 
  To: [EMAIL PROTECTED] 
  Sent: Thursday, January 29, 2004 10:40 AM
  Subject: The final script! but still some problems..


  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..