Final 2006 overall ranking

$mytable = array();

// Title
$myheader = array("Rank","Name","Nation","Glider","Points");

$myquery = db_query("SELECT PWC_RANK, SURNAME, FIRST_NAME, NAT, GLIDER, OVERALL from 2006_SCORE_PWC where OVERALL>0 order by PWC_RANK");

while ($myresult = db_fetch_array($myquery))
$mytable[] = array($myresult["PWC_RANK"], $myresult["SURNAME"]." ".$myresult["FIRST_NAME"], $myresult["NAT"], $myresult["GLIDER"], $myresult["OVERALL"]);

echo theme_table($myheader, $mytable);

?>