$RightLoginTime = 'LoginTime'; $Distance = 'Distance'; $LessonNumber = 'LessonNumber'; $LessonsTimeLimit = "30";
So $Distance is a string equaling "Distance" and $LessonNumber = "LessonNumber" How are you performing math on a string? -Dave
At 01:42 PM 1/28/2004, Radwan Aladdin wrote:
I'm using the GET method..
And it is right.. it shows the correct GET method.. the problem in is in the Destance value.. it is not updating this value to the database.. or it is wrong.. every time = 0
So what is the error?
Regards.. ----- Original Message ----- From: "David OBrien" <[EMAIL PROTECTED]> To: "Radwan Aladdin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, January 28, 2004 10:34 PM Subject: Re: [PHP] Still error messages!!
> I assume you are using another page with a form to enter the username and
> password?
> If so:
> add as the first line of your script right after the <?PHP
>
> phpinfo();
>
> Run your application, scroll to the bottom and look at the "php variables"
> and make sure that your are asking for $_GET["Username"] and
> $_GET["Password"] are what the script sees
>
> If not:
> You may have to run just that page
> with http://whatever/whatever.php?Username=whatever&Password=whatever to
> see if the problem is in the form or not
>
> -Dave
>
>
> At 01:08 PM 1/28/2004, Radwan Aladdin wrote:
> >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
> > >
>
>
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
