|
$Query = "SELECT * FROM br_league WHERE LeagueYear=$Year ORDER BY Other ASC, League";
$Result = $Db->db_query($Query);
while ($Row = $Db->db_array($Result))
{
echo " ".$Row["League"]." \n";
echo "";
$Query = "SELECT * FROM br_league_spec WHERE LeagueID='".$Row["ID"]."' ORDER BY Pool";
$ResSpec = $Db->db_query($Query);
if (!$ResSpec)
die ("Chyba při dotazu na data !!! (2001)");
if ($Db->db_numrows($ResSpec) > 0)
$Query = "SELECT B.* FROM br_league_spec A, br_competitions B WHERE A.LeagueID='".$Row["ID"]."' AND B.ID=A.CompID AND B.ShowComp='1' ORDER BY A.Pool";
else
$Query = "SELECT * FROM br_competitions WHERE LeagueID = ".$Row["ID"]." AND ShowComp=1 ORDER BY Pool";
$Result2 = $Db->db_query($Query);
while ($Row2 = $Db->db_array($Result2))
{
echo "\n";
}
echo " ";
if (empty($Row["TextView"]))
{
echo "- Celkové (průběžné) výsledky - SCORE
";
echo "- Celkové (průběžné) výsledky - PRECISION
";
}
else
echo "- ".$Row["TextView"]."
";
echo " \n";
}
$Query = "SELECT * FROM br_competitions WHERE CompYear=$Year AND LeagueID=0 AND ShowComp=1 ORDER BY CompMonth, CompDay";
$Result = $Db->db_query($Query);
if ($Db->db_numrows($Result) > 0)
{
echo " ";
echo "Ostatní (neligové) soutěže v benchrestu \n";
echo "";
while ($Row = $Db->db_array($Result))
{
echo "\n";
}
echo " ";
echo " ";
}
?>
|
|
|