On Mar 14, 2008, at 5:03 PM, TG wrote:

>
>
>
> ----- Original Message -----
> From: Jason Pruim <japruim@raoset.com>
> To: TG <tg-php@gryffyndevelopment.com>
> Cc: "PHP General List" <php-general@lists.php.net>
> Date: Fri, 14 Mar 2008 14:56:32 -0400
> Subject: Re: [php] 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;
>
>
> 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.
>
>
> Usually when I get errors like this, it's because a variable I
> expect to be
> populated isn't and it messes up the SQL by leaving a blank where it
> expects something.
>
> SELECT * FROM users WHERE username = 'tg' ORDER BY LName
>
> If I had:
>
> $user = "'tg'"
>
> with the single-quotes inside the variable.. if I typo'd on $user
> and did
> something like:
>
> $query = "SELECT * FROM users WHERE username = $usr ORDER BY LName";
>
> Then I'd get:
>
> SELECT * FROM users WHERE username = ORDER BY LName

--

Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
3251 132nd ave
Holland, MI, 49424-9337
www.raoset.com
japruim@raoset.com