Forums
This topic is locked
Mysql Limiting records
Posted 15 Jul 2003 22:13:54
1
has voted
15 Jul 2003 22:13:54 Saeed Abdi posted:
Have a page that lists all of the articles in the db (Archive), it shows 10 records and people can cycle through the pages, the page does what I need now, but I would very much like to remove the latest articles as they are always shown on the front page, my problem begins when I use "LIMIT" in my query(LIMT 4,10) if I use the test within the query builder it returns perfect results, but as soon as I click OK and I test the page I get this error " You have an error in your SQL syntax near 'LIMIT 0, 10' at line 1"Any help is appreciated
Query:
SELECT * FROM indepth
ORDER BY SubDate DESC LIMIT 4, 8
Additional info:
Dreamweaver MX, PHP, MYsql, Win2000, IIS5