Can anyone please help me. I don't know how I can integrate this pagination scipt into my already existing coding. Here is my pagination script:
//connect to database then
if(!$rowstart) $rowstart=0;
$result = mysql_query("select username from user limit $rowstart,5");
$result2 = mysql_query("select username from user");
//put all the code here for running the script itself using $result in the while loop
if ($rowstart>$numrows)
{?>
<A HREF="<? $php_self ?>?rowstart=<? echo $rowstart-5;?>">
< Previous Page</A>
<?}?>
|
<?
$numrows=mysql_num_rows($result2);
if($rowstart+5<$numrows)
{?>
<A HREF="<? $php_self?>?rowstart=<?echo $rowstart+5 ;?>">
Next Page ></A>
<? } ?>
Then the page I want to implement the pagination into
$max=10; //This number decides how many results to display
$referrers = $DB_site->query("SELECT COUNT(*) AS referrals, user.username, user.userid FROM user AS users
LEFT JOIN user ON (users.referrerid = user.userid)
WHERE user.userid > 0
GROUP BY users.referrerid
ORDER BY referrals DESC
LIMIT $max");
while ($referrer=$DB_site->fetch_array($referrers)) {
$referreds = $DB_site->query("SELECT username FROM user WHERE referrerid = '$referrer[userid]' AND referrerid > 0");
while ($referred = $DB_site->fetch_array($referreds)){
$enc_username = urlencode($referred[username]);
if ($referrerlist) {
$referrerlist .= ", <A HREF=member.php?action=getinfo&username=$enc_username>$referred[username]</A>";
} else {
$referrerlist .= "<A HREF=member.php?action=getinfo&username=$enc_username>$referred[username]</A>";
}
}
eval("\$referbits .= \"".fetch_template("referbit")."\";");
$referrerlist="";
}
eval('print_output("' . fetch_template('refer') . '");');
I only want results for 15 users per page, can anyone follow me on this??? PLEASE HELP
