Here's the HOF that I use - not much, but hope it helps ya.....
<?
include 'header.php';
?>
<tr><td class="contenthead">Hall Of Fame</td></tr>
<tr><td class="contentcontent"><center>[url="halloffame.php?view=exp"]Level[/url] | [url="halloffame.php?view=strength"]Strength[/url] | [url="halloffame.php?view=defense"]Defense[/url] | [url="halloffame.php?view=speed"]Speed[/url] | [url="halloffame.php?view=money"]Money[/url] | [url="halloffame.php?view=points"]Points[/url]</center></td></tr>
<tr><td class="contentcontent">
<table width='100%'>
<tr>
<td>Rank</td>
<td>Mobster</td>
<td>Level</td>
<td>Money</td>
<td>Gang</td>
<td align='center'>Online</td>
</tr>
<?
$view = ($_GET['view'] != "") ? $_GET['view'] : 'exp';
?
$result = mysql_query("SELECT * FROM `grpgusers` ORDER BY `".$view."` DESC LIMIT 50");
$rank = 0;
while($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
$rank++;
$user_hall = new User($line['id']);
?>
<tr>
<td><?= $rank ?></td>
<td><?= $user_hall->formattedname ?></td>
<td><?= $user_hall->level ?></td>
<td>$<?= $user_hall->money ?></td>
<td><?= $user_hall->formattedgang ?></td>
<td><?= $user_hall->formattedonline ?></td>
</tr>
<?
}
?>
</td></tr>
<?
include 'footer.php';
?>