Top Handicappers

debug = TRUE; $db->setTable("contestants"); $db->query("select count(*) from contestants where confirmed = 1"); if ($r = $db->fetchRow()) { $total = $r[0]; } $db->free(); $db->query("select count(*) from contestants where active = 1 and confirmed = 1"); if ($r = $db->fetchRow()) { $active = $r[0]; } $db->free(); $db->query("select count(*) from contestants where active = 0 and confirmed = 1"); if ($r = $db->fetchRow()) { $inactive = $r[0]; } $db->free(); ?>
PLAYERS STILL IN: 
PLAYERS OUT:

TOTAL PLAYERS:

query("SELECT active,username,wins,places,shows,date_format(disqualdate, '%M %D'),disqualrace,uid FROM contestants where confirmed = 1 order by active desc, disqualdate desc, disqualrace desc, wins desc, places desc, shows desc limit $num"); while ($r = $db->fetchRef()) { //$color = "#005000"; if ($r[0]) { $color = "#005000"; } else { $color="#b00000"; } if (strtolower($r[1]) == strtolower($logincookie)) { $rcolor = "#ffffaa"; } else { $rcolor="#fffffa"; } echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; $a++; } ?>
RANK HANDICAPPER WINS PLACES SHOWS ELIMINATED RACE
$a$r[1]$r[2]$r[3]$r[4]"; if ($r[5] == "") { echo "-"; } echo "$r[5]"; if ($r[6] == "") { echo "-"; } echo "$r[6]