On Mar 14, 2008, at 7:44 PM, Jim Lucas wrote:
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.
Requested statement below:
$query = "SELECT * from ".$linkauth['table']." order by ".$sortOrder;
The $linkauth['table'] is returned when the authentication is
successful. Otherwise it's not written so that you have to log in to
see the contents of the database.
--
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
--
Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
3251 132nd ave
Holland, MI, 49424-9337
www.raoset.com
japruim@xxxxxxxxxx
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
