essjay_d12 Posted June 8, 2007 Share Posted June 8, 2007 How would I get just the 10th to the 20th items from a table when ordered by date etc so it skips the first 9 items - and skips any items after the 20th any ideas? cheers d Link to comment https://forums.phpfreaks.com/topic/54746-i-want-the-10th-to-20th-items-ordered-by-date/ Share on other sites More sharing options...
pikemsu28 Posted June 8, 2007 Share Posted June 8, 2007 $query = "select * from table LIMIT 9, 10"; Link to comment https://forums.phpfreaks.com/topic/54746-i-want-the-10th-to-20th-items-ordered-by-date/#findComment-270762 Share on other sites More sharing options...
TreeNode Posted June 8, 2007 Share Posted June 8, 2007 SELECT * FROM someTable ORDER BY theDate ASC LIMIT 9, 10 Link to comment https://forums.phpfreaks.com/topic/54746-i-want-the-10th-to-20th-items-ordered-by-date/#findComment-270813 Share on other sites More sharing options...
pikemsu28 Posted June 8, 2007 Share Posted June 8, 2007 good call tree, i forgot the order by. Link to comment https://forums.phpfreaks.com/topic/54746-i-want-the-10th-to-20th-items-ordered-by-date/#findComment-270817 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.