print <<<EOT
</tr>
EOT;
$ret = mysql_query("select first,last,club.name from player,club where player.club=club.code order by {$order}");
if ($ret && mysql_num_rows($ret)) {
$lclub = "not set";
$linit = "-";
$lrank = new Rank(4000);
while ($row = mysql_fetch_assoc($ret)) {
$p = new Player($row["first"], $row["last"]);
$p->fetchdets();
$club = $row["name"];
$nrank = $p->Rank;
if ($byrank) {
if ($lrank->notequals($nrank)) {
$lrank = $nrank;
print <<<EOT
<tr>
<th colspan={$cs} align="center">
<a name="{$nrank->anchor()}"></a>
<a href="#Top">{$nrank->display()}</a>
</th>
</tr>
EOT;
}
} elseif ($pclub) {
$pinit = $p->get_initial();
if ($linit != $pinit) {
$linit = $pinit;
print <<<EOT
