I want to limit the results to the 2nd - 7th entries in the database. I have:
$query = "SELECT ID, headline, intro, date_format(date, '%M %D')as todays_date FROM news ORDER BY ID DESC LIMIT 2, 7";
But it is not working, any assistance please?
you mean the first 2-7 or the last? your ORDER BY has DESC which means it will be in reverse order.
LIMIT 1, 5
LIMIT [offset], rowcount
offsets start at 0, so 1 is the second entry, and show 5 rows, will show 2-7
