$hauf = array (0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
$ergebnis = array ("1:0","2:0","2:1","3:0","3:1","3:2","4:0","4:1","4:2","4:3","5:0","5:1","5:2","5:3","5:4","6:0","6:1","6:2","6:3","6:4","8:3","9:0");
$sql = mysql_query("SELECT * FROM spiele WHERE pkt = 0;"); // Niederlagen
while ($ds = mysql_fetch_object($sql)){
$heim = $ds -> heim;
$gast = $ds -> gast;
$ee = $ds -> ee;
$he = $ds -> he;
$pkt = $ds -> pkt;
$tpl = $ds -> tpl;
$tmin = $ds -> tmin;
$nr = $ds -> nr;
$art = $ds -> art;
$bem= $ds -> bem;
$bem2 = $ds -> bem2;
if ($tpl === "0" AND $tmin === "1") { // ............. 1:0
$hauf[0] = $hauf[0] + 1;
}
if ($tpl === "0" AND $tmin === "2") { //.............. 2:0
$hauf[1] = $hauf[1] + 1;
}
if ($tpl === "1" AND $tmin === "2") { //.............. 2:1
$hauf[2] = $hauf[2] + 1;
}
if ($tpl === "0" AND $tmin === "3") { //.............. 3:0
$hauf[3] = $hauf[3] + 1;
}
if ($tpl === "1" AND $tmin === "3") { //.............. 3:1
$hauf[4] = $hauf[4] + 1;
}
if ($tpl === "2" AND $tmin === "3") { //.............. 3:2
$hauf[5] = $hauf[5] + 1;
}
if ($tpl === "0" AND $tmin === "4") { //.............. 4:0
$hauf[6] = $hauf[6] + 1;
}
if ($tpl === "1" AND $tmin === "4") { //.............. 4:1
$hauf[7] = $hauf[7] + 1;
}
if ($tpl === "2" AND $tmin === "4") { //.............. 4:2
$hauf[8] = $hauf[8] + 1;
}
if ($tpl === "3" AND $tmin === "4") { //.............. 4:3
$hauf[9] = $hauf[9] + 1;
}
if ($tpl === "0" AND $tmin === "5") { //.............. 5:0
$hauf[10] = $hauf[10] + 1;
}
if ($tpl === "1" AND $tmin === "5") { //.............. 5:1
$hauf[11] = $hauf[11] + 1;
}
if ($tpl === "2" AND $tmin === "5") { //.............. 5:2
$hauf[12] = $hauf[12] + 1;
}
if ($tpl === "3" AND $tmin === "5") { //.............. 5:3
$hauf[13] = $hauf[13] + 1;
}
if ($tpl === "4" AND $tmin === "5") { //.............. 5:4
$hauf[14] = $hauf[14] + 1;
}
if ($tpl === "0" AND $tmin === "6") { //.............. 6:0
$hauf[15] = $hauf[15] + 1;
}
if ($tpl === "1" AND $tmin === "6") { //.............. 6:1
$hauf[16] = $hauf[16] + 1;
}
if ($tpl === "2" AND $tmin === "6") { //.............. 6:2
$hauf[17] = $hauf[17] + 1;
}
if ($tpl === "3" AND $tmin === "6") { //.............. 6:3
$hauf[18] = $hauf[18] + 1;
}
if ($tpl === "4" AND $tmin === "6") { //.............. 6:4
$hauf[19] = $hauf[19] + 1;
}
if ($tpl === "3" AND $tmin === "8") { //.............. 8:3
$hauf[20] = $hauf[20] + 1;
}
if ($tpl === "0" AND $tmin === "9") { //.............. 9:0
$hauf[21] = $hauf[21] + 1;
}
}
// ................. Ende SQL ...................................
?>
| Erg |
Anz |
Darstellung |
for ($x = 0; $x < 22; $x++){
$sterne[$x] = str_repeat("X", $hauf[$x]);
?>
|
|
|
}
mysql_close($dz);
?>