Guest Posted November 28, 2004 Share Posted November 28, 2004 Everything seems to work just fine with one exception. When I click on the "-" to sort Access in descending order, I get the following error message (all of the other fields sort in ascending and descending order just fine). Suggestions will be appreciated. ERROR MESSAGE: 1064 - 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 'DESCcustomers_id' at line 1 select count(*) as total from visitors WHERE browser_language != 'robot' ORDER BY counter DESCcustomers_id Quote Link to comment Share on other sites More sharing options...
Guest Posted November 28, 2004 Share Posted November 28, 2004 you probably need a space: DESCcustomers_id thus you will need to find that in your source code and add it so: DESC customers_id Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.