top 100 list

[jasondavis]

Im working on a top 100 list well top 10 for testing right now im having some trouble I attached a text file which shows the output of the code

<table width="100%">
<tr><td>d</td><td>Name</td><td>Rank</td><td>Refferals</td></tr>
<?
// make top 100 list

$res = mysql_query("select SQL_CACHE * from friend_reg_user order by refnumber desc limit 10");
$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'];
	$picture = show_user_photo($top100['auto_id'],$photo_type='big',$user_name='yes');
		$list .= "<td>$picture</td><td>$disp_name</td><td><b>rank number will be here</b> </td><td>$refnumber </td>" ;
		$list .= "</tr>" ;
}
//$list .= "";

echo $list;

?></table>

the result of $picture returns this

<div style='height:;width:; overflow:hidden' align='center'><a href='index.php?action=memberprofile&type=common&userid=100&unid='><img src='uploded_files/userphoto/nopic.gif'    border=0></a></div>

But instead of doing it on the table cell it does it for all 10 in a row above the table

[laserlight]

It depends on your database engine, but the SQL statement might be along the lines of:

SELECT refnumber, username FROM friend_reg_user ORDER BY refnumber DESC LIMIT 100;

[jasondavis]

laserlight wrote:

It depends on your database engine, but the SQL statement might be along the lines of:

SELECT refnumber, username FROM friend_reg_user ORDER BY refnumber DESC LIMIT 100;

i updated code above with my new code and new problem