Auswertung der Saisons - nach Rennen
Es wird die seit 2010 benutzte Punktwertung verwendet!
Punkteränge
";
echo "Name | ";
echo "Pkt | ";
echo "";
$sql = mysql_query("SELECT * FROM f1_saisons WHERE ($r <> 0 AND $r <> 99) ORDER BY $r DESC;");
while ($ds = mysql_fetch_object($sql)){
$name = $ds -> name;
$rennen = $ds -> $r;
echo "";
echo "| $name";
echo " | $rennen";
echo " |
";
}
//--------------------------------------------------------
$sql = mysql_query("SELECT * FROM f1_rennen WHERE nr = $k;");
while ($ds = mysql_fetch_object($sql)){
$datum = $ds -> datum;
$ort = $ds -> ort;
$pole = $ds -> pole;
$sr = $ds -> sr;
$gp = $ds -> gp;
}
//----------------------------------------------------------
$sql = mysql_query("SELECT * FROM f1_abbruch WHERE nr = $k;");
while ($ds = mysql_fetch_object($sql)){
$bes = $ds -> bes;
}
//----------------------------------------------------------
$sql = mysql_query("SELECT * FROM f1_tod WHERE nr = $k;");
while ($ds = mysql_fetch_object($sql)){
$name = $ds -> name;
$nat = $ds -> nat;
$unfall = $ds -> unfall;
$bes = "$name"." ("."$nat".") "."tödlich verunglückt -"." "."$unfall";
}
//----------------------------------------------------------
?>
";
echo "GP von"." "."$gp";
echo "
";
echo "
";
echo "Pole:"." "."$pole";
echo "
";
echo "
";
echo "Schn.Runde:"." "."$sr";
echo "
";
echo "
";
if ($bes == ' ') {
echo "...."." "."$bes";
} else {
echo "Besonderes:"." "."$bes";
}
?>
Weitere Rennteilnehmer ohne Punkte
";
echo "| Name | ";
echo "";
$sql = mysql_query("SELECT * FROM f1_saisons WHERE $r = 99 ;");
while ($ds = mysql_fetch_object($sql)){
$name = $ds -> name;
$rennen = $ds -> $r;
echo "";
echo "| $name";
echo " |
";
}
mysql_close($dz);
?>