bouwob Posted May 25, 2007 Share Posted May 25, 2007 so I have a table that has 7000 rows. part of the app only allows 100 rows to be chosen at a time. so i have page forward and page back links. The problem though is that if I hit back it always goes to the beginning of the table. How can I use limit to select the last 100 rows in a query? using desc is not applicable btw. tia Quote Link to comment https://forums.phpfreaks.com/topic/52892-bottom-100-with-limit/ Share on other sites More sharing options...
MadTechie Posted May 25, 2007 Share Posted May 25, 2007 can you post some code ! Quote Link to comment https://forums.phpfreaks.com/topic/52892-bottom-100-with-limit/#findComment-261209 Share on other sites More sharing options...
AndyB Posted May 25, 2007 Share Posted May 25, 2007 SELECT * FROM tablename LIMIT $start, $num_records (and set $start to 6900) Quote Link to comment https://forums.phpfreaks.com/topic/52892-bottom-100-with-limit/#findComment-261210 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.