NSW42 Posted October 21, 2008 Share Posted October 21, 2008 Heya Guys, Im not sure how to do this and guess why im here again.. the code below works fine, but what id like is for only 10 users per page to show, and they click page 2 etc to view more, is there a way to do this.. Regards oops the code below lol <?php include('config.php'); $xpagedocol = 'D3D3D3'; $userselect = mysql_query("SELECT * FROM users ORDER BY id DESC"); $num = mysql_num_rows($userselect); print(" <TABLE width=100% heigth=100% bgcolor=#$xpagedocol cellspacing=0> <TR> <TD align=left><font color=#FFFFFF> <img src=favicon.ico> <b>$sitename Memberlist.</b></font></TD> </TR> </TABLE> <BR> <BR> <center> <table width=95% bordercolor='#$xpagedocol' border='2'> <tr> <td class='content'><b>Nickname</b></td> <td class='content'><b>Local</b></td> <td class='content'><b>Gender</b></td> </tr> "); if($num==0) { print("<tr><td class='content' colspan=10>There are 0 users that start with the letter/number $letter</td></tr>"); } while($row = mysql_fetch_array($userselect)) { $pronickx = ($row[nickname]); print(" <tr> <td class='content'> $row[id] - <A href='./?dirx=look&epuid=$row[id]'>$pronickx</a></td> <td class='content'>$row[local]</td> <td class='content'> "); print ("$row[gender]"); print (" </td> </tr> "); } print("</table></center><br> <TABLE width=100% heigth=100% bgcolor=#$xpagedocol cellspacing=0> <TR> <TD align=left><font color=#FFFFFF>  </font></TD> </TR> </TABLE> "); ?> Link to comment https://forums.phpfreaks.com/topic/129345-solved-show-only-10-users-on-each-members-page/ Share on other sites More sharing options...
Maq Posted October 21, 2008 Share Posted October 21, 2008 What code? Link to comment https://forums.phpfreaks.com/topic/129345-solved-show-only-10-users-on-each-members-page/#findComment-670566 Share on other sites More sharing options...
NSW42 Posted October 21, 2008 Author Share Posted October 21, 2008 What code? yeh bad hair day for me I think lol Link to comment https://forums.phpfreaks.com/topic/129345-solved-show-only-10-users-on-each-members-page/#findComment-670570 Share on other sites More sharing options...
NSW42 Posted October 21, 2008 Author Share Posted October 21, 2008 just to update duh me again :-\ I limit the page to 10 users, but how do I go about it showing a page with the next 10 users etc like page 2 at the bottom for users to click Regards Link to comment https://forums.phpfreaks.com/topic/129345-solved-show-only-10-users-on-each-members-page/#findComment-670585 Share on other sites More sharing options...
NSW42 Posted October 21, 2008 Author Share Posted October 21, 2008 heya, well i kinda screwed around with things and did what I needed, so for those who may need something like this, the working code is below.. <?php include('config.php'); $xpagedocol = 'D3D3D3'; // If current page number, use it // if not, set one! if(!isset($_GET['page'])){ $page = 1; } else { $page = $_GET['page']; } // Define the number of results per page $max_results = 3; // Figure out the limit for the query based // on the current page number. $from = (($page * $max_results) - $max_results); // Perform MySQL query on only the current page number's results $userselect = mysql_query("SELECT * FROM users LIMIT $from, $max_results"); $num = mysql_num_rows($userselect); print(" <TABLE width=100% heigth=100% bgcolor=#$xpagedocol cellspacing=0> <TR> <TD align=left><font color=#FFFFFF> <img src=favicon.ico> <b>$sitename Memberlist.</b></font></TD> </TR> </TABLE> <BR> <BR> <center> <table width=95% bordercolor='#$xpagedocol' border='2'> <tr> <td class='content'><b>Nickname</b></td> <td class='content'><b>Local</b></td> <td class='content'><b>Gender</b></td> </tr> "); if($num==0) { print("<tr><td class='content' colspan=10>There are 0 users that start with the letter/number $letter</td></tr>"); } while($row = mysql_fetch_array($userselect)) { $pronickx = ($row[nickname]); print(" <tr> <td class='content'> $row[id] - <A href='./?dirx=look&epuid=$row[id]'>$pronickx</a></td> <td class='content'>$row[local]</td> <td class='content'> "); print ("$row[gender]"); print (" </td> </tr> "); } print("</table></center><br> <TABLE width=100% heigth=100% bgcolor=#$xpagedocol cellspacing=0> <TR> <TD align=left><font color=#FFFFFF>  </font></TD> </TR> </TABLE> "); // Figure out the total number of results in DB: $total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM users"),0); // Figure out the total number of pages. Always round up using ceil() $total_pages = ceil($total_results / $max_results); // Build Page Number Hyperlinks echo "<center>Select a Page<br />"; // Build Previous Link if($page > 1){ $prev = ($page - 1); echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$prev\"><<Previous</a> "; } for($i = 1; $i <= $total_pages; $i++){ if(($page) == $i){ echo "$i "; } else { echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$i\">$i</a> "; } } // Build Next Link if($page < $total_pages){ $next = ($page + 1); echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$next\">Next</a>"; } echo "</center>"; ?></td> <td> </td> </tr> <tr> <td> </td> <td> </td> </tr> </table> Link to comment https://forums.phpfreaks.com/topic/129345-solved-show-only-10-users-on-each-members-page/#findComment-670775 Share on other sites More sharing options...
Maq Posted October 21, 2008 Share Posted October 21, 2008 I think what you're referring to is Pagination. There is a good tutorial for pagination on this site, check it out! Link to comment https://forums.phpfreaks.com/topic/129345-solved-show-only-10-users-on-each-members-page/#findComment-671315 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.