Re: Still error messages!!

At 02:45 PM 1/28/2004, Radwan Aladdin wrote:

Now I fixed the error message.. but the problem is in "Distance = 0" always.. because the LoginTime is a string.. I fetch it but the same thing!! This is the new script : <?php phpinfo(); 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";

You are not executing this query anywhere in the script

$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);

Great that you used this to get the results in a row but you need to reference the row in your script

$query3 = "UPDATE accounts SET LessonNumber=LessonNumber + 1";

Instead of

$RightLoginTime = 'LoginTime'; use

$RightLoginTime = $row2["LoginTime"]; but you need to do a mysql_query for the $query1 and get that value frst Instead of

$Distance = 'Distance'; use

$Distance = $row2["Distance"]; Instead of

$LessonNumber = 'LessonNumber'; use

$LessonNumber = $row2["LessonNumber"]; The user comments on the online manual are a very good starting point for basic programming steps needed to accomplish a task If you would have taken the example on that page you would have seen the steps needed: set your query string execute the query get the resultset into a variable This is the norm for all mysql php programming just putting a $Distance='Distance' does not tell php that what you really want it do read the database and place the value of Distance into $Distance -Dave

$LessonsTimeLimit = "30"; ?> <pre> <? echo $query1; echo $query2; echo $query3; ?> </pre> <? $query4 = "UPDATE accounts SET Distance=" . $LogoutTime - $RightLoginTime . " - LoginTime WHERE UserName=" . $UserName . " AND Password=" . $Password . ")"; $result4 = mysql_query($query4) or die("Query error: " . mysql_error()); $row4 = mysql_fetch_row($result4); ?> <pre> <? echo $query4; ?> </pre> <? if($Distance == $LessonsTimeLimit){

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

}else{

    echo "Not yet!";

} ?> So why it is making the Distance value = 0 and it doen't update the value in the database. (Because it must update the value in the database by it) Regards.. ----- Original Message ----- From: "John Nichel" <jnichel@by-tor.com> To: "Radwan Aladdin" <raladin@emirates.net.ae> Cc: <php-general@lists.php.net> Sent: Wednesday, January 28, 2004 11:37 PM Subject: Re: [PHP] Still error messages!! Radwan Aladdin wrote: <snip>

So where are the errors? Waiting your help please.. Regards..

What's the error message??? -- By-Tor.com It's all about the Rush http://www.by-tor.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php