Thank for your reply..
But I'm not trying to echo these queries.. What I'm trying to do is :
To UPDATE a value in the database (Login_Time and Logout_Time) and then
caculate the distance between them and put it in (Distance) field.. then
after that program the PHP file and put in it a LessonLimit value.. if the
LessonLimit is the same of the Distance.. then make a value in that row
(LessonNumber) = Its currently value + 1 (So for example : is LessonNumber =
2 then it must be 3...Etc..)
Hope you got my meaning..
The error that is displayed always is : "Query error: You have an error in
your SQL syntax near '0') WHERE UserName=
AND Password=)' at line 1"
Also when I put the right UserName and Password.. the same error!!
So also there are some other errors.. please see the whole script..
Waiting your help..
Regards..
----- Original Message -----
From: "David OBrien" <[EMAIL PROTECTED]>
To: "Radwan Aladdin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, January 28, 2004 9:35 PM
Subject: Re: [PHP] Still error messages!!
> At 12:08 PM 1/28/2004, Radwan Aladdin wrote:
> >Hello all..
> >
> >This is the PHP code :
> >
> ><?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";
>
>
> right here do a
>
> ?> <pre> <?
> echo $query1;
> echo $query2;
> echo $query3;
> ?> </pre> <?
>
> and make sure the queries are what you want them to be...
>
> >$result = mysql_query($query1) or die("Query error: " . mysql_error());
> >
> >
> >$RightLoginTime = 'LoginTime';
> >$Distance = 'Distance';
> >$LessonNumber = 'LessonNumber';
> >$LessonsTimeLimit = "30";
> >
> >$query4 = "UPDATE accounts SET (Distance='" . $LogoutTime -
> >$RightLoginTime . "') WHERE UserName=" . $UserName . " AND Password=" .
> >$Password . ")";
>
> Do the same here for query4
>
> >$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!";
> >}
> >
> >?>
>
> --
> 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
