Okay, say I have a table that had 100 records in it. And I want to select records 20 - 40. Now there is no id or number column. Is there a way to select * from table, order by date desc, numbers 20 - 40?
You can use the LIMIT. The syntax is...
LIMIT where_to_start, how_many_record
Since you want 20 records starting at the 20th record, its...
select * from table order by date desc LIMIT 20, 20
Allrightey, thanks.
What I am doing, is making a message board, and I want to order the posts into pages.
