I am using a query to place news items on a link page. Items are in the DB and I can get at them using:
SELECT * FROM tblName WHERE YEAR(articleDate) = YEAR(CURDATE()) AND MONTH(articleDate) = MONTH(CURDATE())What I would like to also do, is limit this query to not include the 4 most recent (they are being displayed on another page).
I can of course, sort by other criteria in the DB, such as title, source ID etc, but thought this way would be the best for what I want
With my experimenting, I've found that LIMIT isn't quite what I want. Is there something else that would do what I need?