$myrow[" idCom" ],
$myrow[" mini_img" ],
$myrow[" idCom" ],
$myrow[" NameCom" ],
$myrow[" Gorod" ]);
$i++;
}
while ($i<2 && $myrow = mysql_fetch_array ($result));
printf («»);
}
while ($myrow = mysql_fetch_array ($result));
?>
View_match.php
include («blocks/bd.php»);/* Π‘ΠΎΠ΅Π΄ΠΈΠ½ΡΠ΅ΠΌΡΡ Ρ ΠΠ */
$idMatch=$_GET['id'];
?>
include(" blocks/header.php" );?>
!—ΠΠ΅Π²ΡΠΉ Π±Π»ΠΎΠΊ—>
|
table.php
include («blocks/bd.php»);/* Π‘ΠΎΠ΅Π΄ΠΈΠ½ΡΠ΅ΠΌΡΡ Ρ ΠΠ */
if (isset ($_GET['year']))
{$year = $_GET['year'];
$wyear=" and Year='$year'" ;}
else {$wyear='';}
?>
include(" blocks/header.php" );?>
$zapros="SELECT ID, NameCom, Gorod, sum (igrDoma) igr, sum (zab)-sum (prop) mjach, sum (ochki) ochki, sum (vdoma) vdoma, sum (ndoma) ndoma, sum (pdoma) pdoma, sum (vgost) vgost, sum (ngost) ngost, sum (pgost) pgost, sum (prgost) prgost, sum (zabgost) zabgost, sum (prdoma) prdoma, sum (zabdoma) zabdoma FROM ( SELECT Command. idCom as ID, NameCom, Gorod, count (Gost) as igrDoma, PropMjach zab, ZabMjach prop, CASE WHEN PropMjach-ZabMjach>0 THEN '3' WHEN PropMjach-ZabMjach=0 THEN '1' ELSE '0' END ochki, CASE WHEN PropMjach-ZabMjach>0 THEN '1' ELSE '0' END vgost, CASE WHEN PropMjach-ZabMjach=0 THEN '1' ELSE '0' END ngost, CASE WHEN PropMjach-ZabMjach<0 THEN '1' ELSE '0' END pgost, 0 vdoma, 0 ndoma, 0 pdoma, PropMjach zabgost, ZabMjach prgost, 0 prdoma, 0 zabdoma FROM Command, Chempionats, MatchRezult, Matches WHERE NameChemp='Π§Π΅ΠΌΠΏΠΈΠΎΠ½Π°Ρ Π ΠΎΡΡΠΈΠΈ' and Matches. idMatch=MatchRezult.idMatch and Command.idCom=Gost and Matches.idChemp=Chempionats.idChemp" .$wyear." GROUP BY MatchRezult. idMatch UNION ALL SELECT Command. idCom as ID, NameCom, Gorod, count (Doma) as igrDoma, ZabMjach zab, PropMjach prop, CASE WHEN PropMjach-ZabMjach<0 THEN '3' WHEN PropMjach-ZabMjach=0 THEN '1' ELSE '0' END ochki, 0,0,0, CASE WHEN PropMjach-ZabMjach<0 THEN '1' ELSE '0' END vgost, CASE WHEN PropMjach-ZabMjach=0 THEN '1' ELSE '0' END ngost, CASE WHEN PropMjach-ZabMjach>0 THEN '1' ELSE '0' END pgost, 0 zabgost, 0 prgost, PropMjach prdoma, ZabMjach zabdoma FROM Command, Chempionats, MatchRezult, Matches WHERE NameChemp='Π§Π΅ΠΌΠΏΠΈΠΎΠ½Π°Ρ Π ΠΎΡΡΠΈΠΈ' and Matches. idMatch=MatchRezult.idMatch and Command.idCom=Doma and Matches.idChemp=Chempionats.idChemp" .$wyear." GROUP BY MatchRezult. idMatch ) xxx GROUP BY ID ORDER BY ochki desc" ; $result = mysql_query ($zapros, $db); $i=1; while ($myrow = mysql_fetch_array ($result)) { printf (« %s. | %s(%s) | %s | %s | %s | %s | %s | %s | %s — %s | %s | %s | %s | %s — %s | ); $i++; } ?>
|
Result.php
include («blocks/bd.php»);/* Π‘ΠΎΠ΅Π΄ΠΈΠ½ΡΠ΅ΠΌΡΡ Ρ ΠΠ */
if (isset ($_GET['year']))
{$year = $_GET['year'];
$wyear=" and Year='$year'" ;}
else {$wyear='';}
?>
include(" blocks/header.php" );?>
$zapros = «SELECT Command. idCom as ID, NameCom, Gorod FROM Command, Chempionats, CommandInChemp WHERE NameChemp='Π§Π΅ΠΌΠΏΠΈΠΎΠ½Π°Ρ Π ΠΎΡΡΠΈΠΈ' and Command.idCom=CommandInChemp.idCom and Chempionats.idChemp=CommandInChemp.idChemp" .$wyear." GROUP BY Command. idCom" ; $result = mysql_query ($zapros, $db); $i=1; $k=1; printf (« ΠΊΠΎΠΌΠ°Π½Π΄Π° | ");while ($myrow = mysql_fetch_array ($result)) { printf (« | ", $i);class='tablerrez'> %s $comarray[$i]=$myrow['ID']; $i++; } printf (« $result = mysql_query ($zapros, $db); while ($myrow = mysql_fetch_array ($result)) { $c=1; $zapis=1; printf (« %s | | " ,$k, $myrow['NameCom'],$myrow['Gorod']);
do { if ($k==$c) { $c++; } else { $vgost = $myrow[" ID" ]; $res3 = mysql_query («SELECT Doma, ZabMjach, PropMjach FROM MatchRezult, Matches, Chempionats WHERE Gost='$vgost' and Matches.idMatch=MatchRezult.idMatch and NameChemp='Π§Π΅ΠΌΠΏΠΈΠΎΠ½Π°Ρ Π ΠΎΡΡΠΈΠΈ' and Chempionats.idChemp=Matches.idChemp" .$wyear." ORDER BY Doma «); $row3 = mysql_fetch_array ($res3); $vdoma = $row3['Doma']; do { $vdoma = $row3['Doma']; if ($comarray[$c]==$vdoma) { $gostarray[$k][$c]=$row3['PropMjach']. «:» .$row3['ZabMjach']; $zapis++; } else if ($k==$c) { $res3 = mysql_query («SELECT Doma, ZabMjach, PropMjach FROM MatchRezult, Matches, Chempionats WHERE Gost='$vgost' and Matches.idMatch=MatchRezult.idMatch and NameChemp='Π§Π΅ΠΌΠΏΠΈΠΎΠ½Π°Ρ Π ΠΎΡΡΠΈΠΈ' and Chempionats.idChemp=Matches.idChemp" .$wyear." ORDER BY Doma «); for ($mas=1;$mas<$c;$mas++) $row3 = mysql_fetch_array ($res3); } else { $res3 = mysql_query («SELECT Doma, ZabMjach, PropMjach FROM MatchRezult, Matches, Chempionats WHERE Gost='$vgost' and Matches.idMatch=MatchRezult.idMatch and NameChemp='Π§Π΅ΠΌΠΏΠΈΠΎΠ½Π°Ρ Π ΠΎΡΡΠΈΠΈ' and Chempionats.idChemp=Matches.idChemp" .$wyear." ORDER BY Doma «); for ($mas=1;$mas<$zapis;$mas++) $row3 = mysql_fetch_array ($res3); } $c++; } while ($c<$i && $row3 = mysql_fetch_array ($res3)); }//else } while ($c<$i); $c=1; $zapis=1; do { if ($k==$c) { printf (« "); | $c++; } else { $doma = $myrow[" ID" ]; $res2 = mysql_query («SELECT Gost, ZabMjach, PropMjach FROM MatchRezult, Matches, Chempionats WHERE Doma='$doma' and Matches.idMatch=MatchRezult.idMatch and NameChemp='Π§Π΅ΠΌΠΏΠΈΠΎΠ½Π°Ρ Π ΠΎΡΡΠΈΠΈ' and Chempionats.idChemp=Matches.idChemp" .$wyear." ORDER BY Gost «); $row2 = mysql_fetch_array ($res2); $gost = $row2['Gost']; if ($gost == '') { printf (« | " ,$gostarray[$k][$c]);
$c++; } else { do { $gost = $row2['Gost']; if ($comarray[$c]==$gost) { printf (« | " ,$row2['ZabMjach'],$row2['PropMjach'],$gostarray[$k][$c]);
$zapis++; } else if ($k==$c) { printf (« "); | $res2 = mysql_query («SELECT Gost, ZabMjach, PropMjach FROM MatchRezult, Matches, Chempionats WHERE Doma='$doma' and Matches.idMatch=MatchRezult.idMatch and NameChemp='Π§Π΅ΠΌΠΏΠΈΠΎΠ½Π°Ρ Π ΠΎΡΡΠΈΠΈ' and Chempionats.idChemp=Matches.idChemp" .$wyear." ORDER BY Gost «); for ($mas=1;$mas<$c;$mas++) $row2 = mysql_fetch_array ($res2); } else { printf (« | " ,$gostarray[$k][$c]);
$res2 = mysql_query («SELECT Gost, ZabMjach, PropMjach FROM MatchRezult, Matches, Chempionats WHERE Doma='$doma' and Matches.idMatch=MatchRezult.idMatch and NameChemp='Π§Π΅ΠΌΠΏΠΈΠΎΠ½Π°Ρ Π ΠΎΡΡΠΈΠΈ' and Chempionats.idChemp=Matches.idChemp" .$wyear." ORDER BY Gost «); for ($mas=1;$mas<$zapis;$mas++) $row2 = mysql_fetch_array ($res2); } $c++; } while ($c<$i && $row2 = mysql_fetch_array ($res2)); } }//else } while ($c<$i); $k++; printf (« } ?>
|
New_match.php
include («blocks/bd.php»);/* Π‘ΠΎΠ΅Π΄ΠΈΠ½ΡΠ΅ΠΌΡΡ Ρ ΠΠ */
?>
include(" blocks/header.php" );?>
add_match.php