gdfhghjdfghgfhf Posted April 22, 2008 Share Posted April 22, 2008 i want to select all the entrys from item #7 to item #13 in a table... how can i do this? i tryed with $query = "SELECT * from bands_pics WHERE bandid = '$id' ORDER BY id DESC LIMIT 7, 13"; but it displays 13 entries and not #7 to #13 Quote Link to comment Share on other sites More sharing options...
Barand Posted April 22, 2008 Share Posted April 22, 2008 LIMIT start_at, how_many $query = "SELECT * from bands_pics WHERE bandid = '$id' ORDER BY id DESC LIMIT 6, 7"; Quote Link to comment Share on other sites More sharing options...
gdfhghjdfghgfhf Posted April 22, 2008 Author Share Posted April 22, 2008 ohhh, damn i'm dumb lol thank you! Quote Link to comment 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.