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 Link to comment https://forums.phpfreaks.com/topic/108674-sql-limit/ 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) Link to comment https://forums.phpfreaks.com/topic/108674-sql-limit/#findComment-557275 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? Link to comment https://forums.phpfreaks.com/topic/108674-sql-limit/#findComment-557276 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. Link to comment https://forums.phpfreaks.com/topic/108674-sql-limit/#findComment-557565 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.