I need this code to have page numbers in it where it would echo the members but will list them in pages instead of a long long list.. how much would this cost to do.
Example :
<<Prev -- 1,2,3,4 -- Next>>
<? ob_start();
include('header.php');
if (!isset($HTTP_SESSION_VARS['userid'])) { header("Location: login.php"); }
$getdata = mysql_query("SELECT * FROM users WHERE userid = '".$HTTP_SESSION_VARS['userid']."'");
$fetchdata = mysql_fetch_array($getdata) or die ('I cannot connect to the database because: ' . mysql_error());
?>
<p>
Below is the list of referrals that have signed up under your
referral link. <br>
See further down for your referral link and
banners to use on your web site.</p>
<table border="0" cellpadding="2" cellspacing="3" style="border-collapse: collapse" bordercolor="#111111" id="AutoNumber25" width="95%">
<tr>
<td width="156" bgcolor="#555555" class="baseline2"><font color="#FFFFFF"><b>Ref ID</b></font></td>
<td width="260" bgcolor="#555555" class="baseline2"><font color="#FFFFFF"><b>Country</b></font></td>
<td width="351" bgcolor="#555555" class="baseline2"><font color="#FFFFFF"><b>Complete Offers</b></font></td>
<td width="225" bgcolor="#555555" class="baseline2"><font color="#FFFFFF"><b>Signup Date</b></font></td>
</tr>
<?
$getdata = mysql_query("SELECT * FROM users WHERE refid = '".$HTTP_SESSION_VARS['userid']."' ORDER BY userid ASC");
while($row = mysql_fetch_array($getdata)) {
$sqli = mysql_query("SELECT * FROM offers_active WHERE username = '".$row['userid']."' AND status = '2'");
$numrowsi = mysql_num_rows($sqli);
?>
<tr>
<td width="156" bgcolor="#F9F9F9" class="baseline"><? echo $row['userid']; ?></td>
<td width="260" bgcolor="#F9F9F9" class="baseline"><? echo $row['country']; ?></td>
<td width="351" bgcolor="#F9F9F9" class="baseline"><? echo $numrowsi; ?></td>
<td width="225" bgcolor="#F9F9F9" class="baseline"><? echo $row['refdate']; ?></td>
</tr>
<? } ?>
</table>
<? include('footer.php'); ?>
|