HGeneAnthony Posted May 31, 2006 Share Posted May 31, 2006 On a lot of websites I notice the ability to jump forward/back x amount of records and I was wondering how it was done. Is there a way to write a SQL query to return only x amount of records or do I load them all and then sort them out myself in PHP. Any help? Quote Link to comment https://forums.phpfreaks.com/topic/10818-how-can-i-have-a-load-the-next-10-records-like-some-websites/ Share on other sites More sharing options...
trq Posted May 31, 2006 Share Posted May 31, 2006 Search for [i]php record paging[/i] tutorials. Quote Link to comment https://forums.phpfreaks.com/topic/10818-how-can-i-have-a-load-the-next-10-records-like-some-websites/#findComment-40441 Share on other sites More sharing options...
iPixel Posted May 31, 2006 Share Posted May 31, 2006 in SQL you can set Limits which will only pull the X amount of records ... and then creating a next page button which will pull the next amount of X records...But yea... Pagination is the keyword u should search around for. Quote Link to comment https://forums.phpfreaks.com/topic/10818-how-can-i-have-a-load-the-next-10-records-like-some-websites/#findComment-40643 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.