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] 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 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"; 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. 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? 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 Link to comment https://forums.phpfreaks.com/topic/192891-pagination/#findComment-1016511 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.