10-08-2007, 05:03 PM
On my forum I have couple of forums that have 6 pages like
1. 2. 3. 4. 5. 6 and whan I try to clik on the 2. or any other 1 it gives me an error lik this
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 '-8, 10' at line 1
Query: SELECT s.*, s.username AS shoutusername, u.username, u.usergroup, u.displaygroup FROM dss_shouts s LEFT JOIN dss_users u ON (u.uid=s.uid) ORDER BY dateline LIMIT -8, 10
Does any 1 know how to fix this,.
1. 2. 3. 4. 5. 6 and whan I try to clik on the 2. or any other 1 it gives me an error lik this
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 '-8, 10' at line 1
Query: SELECT s.*, s.username AS shoutusername, u.username, u.usergroup, u.displaygroup FROM dss_shouts s LEFT JOIN dss_users u ON (u.uid=s.uid) ORDER BY dateline LIMIT -8, 10
Does any 1 know how to fix this,.