Hi all..
I'm sure you are able to fix this.. but I'm new to PHP.. not too much familiar with it..
I made this script, and every time error message :
UPDATE accounts SET LogoutTime=1075354624SELECT LoginTime,Distance,LessonNumber FROM accounts WHERE
UserName='raladin' AND Password='7ad11i18'UPDATE accounts SET LessonNumber=LessonNumber + 1
Query error: You have an error in your SQL syntax near 'WHERE UserName='raladin' AND Password='7ad11i18'' at line 1
This is the code of that PHP file :
<?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());
?> <pre> <?
echo $query4;
?> </pre> <?
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
#
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
#
What I'm trying to do is a PHP file that inserts a LogoutTime to the row of the user (The user = GET UserName).. then after that caculate the distance between the LogoutTime value and the LoginTime value (Imported from that row also).. and then put the result in another field inside that row for that user named (Distance) and then.. if Distance = TimeLimit (LessonsLimit is a variable inside the PHP file $LessonLimit = "30"; for example) then make the value of the field (LessonNumber) = its current value + 1 (So for example : 2 + 1 = 3)
Hope any body know how to fix this..
Waiting your help..
Regards..
