I made that.. but there is something strange!! I SELECTED field from the database.. but it is not showing what it contains!!
This is what is shown on the screen : UPDATE accounts SET LogoutTime=1075313199SELECT LoginTime,Distance,LessonNumber FROM accounts WHERE UserName='' AND Password=''UPDATE accounts SET LessonNumber=LessonNumber + 1 Query error: You have an error in your SQL syntax near '0') WHERE UserName= AND Password=)' at line 1 So what is wrong!!!?? Everything is inserted and updated correctly in the database.. but the distance is the same.. no changes.. no updates!! Regards.. ----- Original Message ----- From: "Damon Hill" <[EMAIL PROTECTED]> To: "'Radwan Aladdin'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, January 28, 2004 9:56 PM Subject: RE: [PHP] Still error messages!! > Correct Radwan, you are NOT trying to echo the queries to the screen. > However, what David is trying to teach you is simply debugging > techniques. > By echoing the actual query that the PHP pareser is using, you can see > if it is indeed what you want it to be. > This way, you can debug the code yourself, instead of posting it to a > list for help. > That way you cut down on the number of email messages I receive and also > learn something in the process. > > Now, echo it to the screen and see what it says :-) > > M Damon Hill > Senior Technical Lead > IFWorld, Inc. > www.ifworld.com > Go Hogs! > "People demand freedom of speech to make up for the freedom of thought > which they avoid." > - Soren Aabye Kierkegaard > > > -----Original Message----- > From: Radwan Aladdin [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 28, 2004 11:50 AM > To: [EMAIL PROTECTED] > Subject: Re: [PHP] Still error messages!! > > > 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 >
