How to set up queries not starting from the first record
I am just trying to set up a page with news items split into three levels. The first is the most recent, and most prominent story, the second the next three stories by date, and lastly a third with the next three.
A bit like the crude layout here:
I'm assuming I would use three queries - the first to display record number 1, the second to display records 2 - 4, and the third to display records 5-7.
I'm assuming this is possible, just not sure of the SQL syntax?
I've been trying LIMIT at the end of the query, e.g.
SELECT NewsID, Item, Date FROM news LIMIT 1, 3
But am getting the error:
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 'LIMIT 0, 20' at line 1
Where Line 1 is just the code for the connection file include.