[SOLVED] show only 10 users on each members page

[NSW42]

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> &nbsp</font></TD>

</TR>

</TABLE>

");

 

 

?>

 

 

 

[Maq]

What code?

[NSW42]

What code?

yeh bad hair day for me I think lol

[NSW42]

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

[NSW42]

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> &nbsp</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>

 

 

[Maq]

I think what you're referring to is Pagination.  There is a good tutorial for pagination on this site, check it out!