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

Reply to this topic