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 Quote 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"; Quote 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 Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.