Jason Pruim wrote:
On Mar 14, 2008, at 5:03 PM, TG wrote:
----- Original Message -----
From: Jason Pruim <japruim@xxxxxxxxxx>
To: TG <tg-php@xxxxxxxxxxxxxxxxxxxxxx>
Cc: "PHP General List" <php-general@xxxxxxxxxxxxx>
Date: Fri, 14 Mar 2008 14:56:32 -0400
Subject: Re: Is this the best way?
On Mar 14, 2008, at 1:44 PM, TG wrote:
What error are you getting? Maybe there's some way to fix that too.
The error I get without checking the row count is this:
You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'order by LName' at line 1
Ok so the next thing to check is your query. Maybe echo it out so you
can
see what's actually attempting to execute.
echo from my actual query
SELECT * FROM current WHERE loginName='japruim' AND
loginPassword='mybadpassword' LIMIT 0,1;
obviously it isn't this SQL statement that is causing the problem, it doesn't
have the ORDER BY piece that is failing.
I don't see an "ORDER BY" in the SQL listed below.
The ORDER BY actually comes from a different query that should ONLY be
done AFTER successful login... It's actually related to the sorting of
the records that should be retrieved.
Somehow it is getting to this statement and the variable that you are using just
before the ORDER BY part is empty, Why don't you show us that statement.
--
Jim Lucas
"Some men are born to greatness, some achieve greatness,
and some have greatness thrust upon them."
Twelfth Night, Act II, Scene V
by William Shakespeare
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
