Cordilo Posted March 30, 2004 Posted March 30, 2004 Great contrib, but if change to counter decs i got an mysql error 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 ORDER BY counter DESCcustomers_id Quote
reppy Posted October 16, 2004 Posted October 16, 2004 Great contrib, but if change to counter decs i got an mysql error 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 ORDER BY counter DESCcustomers_id <{POST_SNAPBACK}> In case anyone else is having this problem, I figured it out. At around line 192, look for: switch ($listing) { case "counter-asc": $order .= "counter"; break; case "counter-desc": $order .= "counter DESC"; After $order .= "counter DESC"; add: break; Quote
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.
Note: Your post will require moderator approval before it will be visible.