karimali831 Posted February 22, 2010 Share Posted February 22, 2010 Can someone show how to setup pagination please? Take a look at attatchment for table structure. Hundreds of these results are being display on the same page causing slow load. [attachment deleted by admin] Quote Link to comment https://forums.phpfreaks.com/topic/192891-pagination/ Share on other sites More sharing options...
Psycho Posted February 22, 2010 Share Posted February 22, 2010 http://www.phpfreaks.com/tutorial/basic-pagination Quote Link to comment https://forums.phpfreaks.com/topic/192891-pagination/#findComment-1015946 Share on other sites More sharing options...
karimali831 Posted February 23, 2010 Author Share Posted February 23, 2010 I'm getting something like : : : : : : : : : : [1] 2 3 4 > >> Something wrong with my query? $sql = "SELECT ID, name, clantag, clanhp, leader, clanlogo, password, server FROM ".PREFIX."cup_all_clans WHERE ID LIMIT $offset, $rowsperpage"; Quote Link to comment https://forums.phpfreaks.com/topic/192891-pagination/#findComment-1016494 Share on other sites More sharing options...
karimali831 Posted February 23, 2010 Author Share Posted February 23, 2010 Ahh, didn't echo data. Solved. Quote Link to comment https://forums.phpfreaks.com/topic/192891-pagination/#findComment-1016497 Share on other sites More sharing options...
karimali831 Posted February 23, 2010 Author Share Posted February 23, 2010 Ok, my problem is links. The results are displayed like index.php?page=clans and when clicking the nextpage it will be index.php?currentpage=1 or something. How to rectify? Quote Link to comment https://forums.phpfreaks.com/topic/192891-pagination/#findComment-1016510 Share on other sites More sharing options...
karimali831 Posted February 23, 2010 Author Share Posted February 23, 2010 Fixed index.php?site=clans¤tpage=$nextpage Quote Link to comment https://forums.phpfreaks.com/topic/192891-pagination/#findComment-1016511 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.