| 
 
			              
				              |  | $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 "\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 "";
														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 " ";
														echo "
 Ostatní (neligové) soutěže v benchrestu \n";
							              echo "
 ";
														while ($Row = $Db->db_array($Result))
														{
															echo "\n";
														}
														echo "";
														echo " ";
													}
						            ?>
 |  |  
 |