Pilots who have not registered yet for Japan...

$cond = "APPLIED_A =0";

$mytable = array();

// Title
$myheader = array(t("Id"),t("First name"),t("Last name"),t("Nation"));

$nb=0;
$myquery = db_query("SELECT NUM, FIRST_NAME, SURNAME, NAT_TEAM from PILOTS where ($cond) and prev_rank !='' order by num, nat_team, surname,first_name");

while ($myresult = db_fetch_array($myquery))
{
$nb++;
$mytable[] = $myresult;
}

if ($nb>0)
echo theme_table($myheader, $mytable);
else
echo t("No one has applied yet to this competition.")
?>