karldesign Posted June 4, 2008 Share Posted June 4, 2008 I am used to using LIMIT 5,5 to select 5 records from after the first 5 records. What I would like to know is how do i select the remaining records from after the 5th record. would that be LIMIT 5,*? cheers Quote Link to comment Share on other sites More sharing options...
luca200 Posted June 4, 2008 Share Posted June 4, 2008 It doesn't make a great sense... LIMIT has the target to limit ( ) the number of rows you get out of a query. What you are asking is not limiting that, actually. You just want to skip 5 rows. I can't figure out something else than fetching all rows and skipping first 5 in your php code (or what else) Quote Link to comment Share on other sites More sharing options...
karldesign Posted June 4, 2008 Author Share Posted June 4, 2008 Yes this is true... I don't want to limit. I tried with the LIMIT 5,* and that did not work. And I didn't want to return the first five rows for the array, so does anyone know a solution? Quote Link to comment Share on other sites More sharing options...
fenway Posted June 4, 2008 Share Posted June 4, 2008 I am used to using LIMIT 5,5 to select 5 records from after the first 5 records. What I would like to know is how do i select the remaining records from after the 5th record. would that be LIMIT 5,*? cheers You can't use negative values anymore, so try LIMIT 5, 999999999999. Or whatever the max number is. 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.