Re: Is this the best way?

On Mar 18, 2008, at 12:26 PM, TG wrote:

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.

Sorry, havn't had a ton of time to go over mailing list messages recently. If I recall, you said that the big issue was that this query shouldn't run if the user isn't logged in. So that would point to an issue with your logic before you get to this point. You might see where you're checking for the user being logged in or not and make sure everything is within the proper "if" grouping. This specific query and the reason you're getting that MySQL error is probably because when a user isn't logged in, your $linkauth['table'] variable is empty. So what you're getting for a SQL statement is: SELECT * from order by <$sortOrder if it's populated>

I think you're spot on here... Time to revisit my authentication function and see if I can streamline it :) -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424-9337 www.raoset.com japruim@raoset.com