Final 2006 women ranking

$mytable = array();

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

$myquery = db_query("SELECT * from 2006_SCORE_PWC where OVERALL>0 AND FEM=TRUE order by PWC_RANK");

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

echo theme_table($myheader, $mytable);

?>