Sorry if this comes up as a double post. I put this up about 20mins ago and nothing happened. I'm assuming it got flagged as spam.
SELECT * FROM blog ORDER BY id DESC LIMIT 7
I made a simple blog and I wanted it to display the first 2 rows from the above query, then put the next 5 into another section. That part works fine. Then you click one of those 5, it kicks up the id # from the link and goes something this, where 3 is the id# and 7 is the max # of records I want to pull up:
SELECT * FROM blog ORDER BY id DESC LIMIT 3,7
This is where the problem is. I expect to get the first row as id #3, then the next is id# 2, then id #1. But thats not whats happening.
Instead, with the above example. I get id #6, #5, #4, then #3.
If I change it to LIMIT 3,7 : I get id# 8 down to #2 and 1 never even comes up.
I change it to LIMIT 13,7 :What I expect to get is first row id # 13, then 7 more down to id #6. but what I get instead is id #3, #2, and #1. Nothing more.
