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 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 ! 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) Link to comment https://forums.phpfreaks.com/topic/52892-bottom-100-with-limit/#findComment-261210 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.