Hi..
I made the following PHP script.. And every time I try it, it shows an error
message... I think there is a wrong with ($LogoutTime - $RightLoginTime'). So please
try to fix the error..
What I want to do is to insert a logout time and if (LogoutTime - LoginTime = 20) for
example.. then make the field "LessonNumber" = "Its value + 1" (2 + 1 = 3 for example)
This is the script :-
<?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 = "INSERT INTO accounts (Distance) ('$LogoutTime - $RightLoginTime')";
$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!";
}
?>
Waiting your replies..
Best regards..