Ok I have the code below to make a top 100 user list what I would like to do though is have it count up like show there rank number as
1
2
3
all the way to 100 any help appreciated
<table width="100%">
<tr>
<td class="member20" colspan="3">Top 100 Refferals</td>
</tr>
<tr><td width="15%" height="25" bgcolor="#00427E" class="headtext" align="center"> Rank</td><td width="61%" height="25" bgcolor="#00427E" class="headtext" align="center">User</td><td width="24%" height="25" bgcolor="#00427E" class="headtext" align="center">Refferals</td></tr>
<?
// make top 100 list
$res = mysql_query("select SQL_CACHE * from friend_reg_user order by refnumber desc limit 100");
$riders = mysql_num_rows($res);
$i=0;
while ($top100 = mysql_fetch_assoc($res))
{
if ($i/1 == ceil($i/1)) $list .= "<tr>";
$i++;
$refnumber = $top100['refnumber'];
$disp_name = $top100['disp_name'];
?>
<tr>
<td height="150" class="member20" align="center"><b>1</b></td>
<td align="center"><?=show_user_photo($top100['auto_id'],$photo_type='small',$user_name='yes');?></td>
<td class="member20" align="center"><?=$refnumber?></td>
</tr>
<? }
?></table>
