|
echo "\n";
$Query = "SELECT A.*, B.RangeAddress FROM br_clubs A, br_ranges B WHERE A.RangeID=B.ID ORDER BY Name";
$Result = $Db->db_query($Query);
if (!$Result)
die ("Chyba při dotazu na data!!!");
while ($Row = $Db->db_array($Result))
{
echo "\n";
echo "".$Row["Name"]." | \n";
echo "";
echo "";
if (!empty($Row["RegNumber"]))
{
echo "Registrační číslo: | \n";
echo "".$Row["RegNumber"]." | \n";
}
if (!empty($Row["RangeAddress"]))
{
echo "Střelnice: | \n";
echo "".$Row["RangeAddress"]." | \n";
}
if (!empty($Row["President"]))
{
echo "Předseda: | \n";
echo "".$Row["President"]." | \n";
}
if (!empty($Row["PresidentPhone"]))
{
echo " | \n";
echo "".$Row["PresidentPhone"]." | \n";
}
if (!empty($Row["PresidentMail"]))
{
echo " | \n";
echo "".$Row["PresidentMail"]." | \n";
}
if (!empty($Row["Executive"]))
{
echo "Jednatel: | \n";
echo "".$Row["Executive"]." | \n";
}
if (!empty($Row["ExecutivePhone"]))
{
echo " | \n";
echo "".$Row["ExecutivePhone"]." | \n";
}
if (!empty($Row["ExecutiveMail"]))
{
echo " | \n";
echo "".$Row["ExecutiveMail"]." | \n";
}
if (!empty($Row["Site"]))
{
echo "WWW stránky: | \n";
echo "".$Row["Site"]." | \n";
}
if (!empty($Row["Events"]))
{
echo "Disciplíny: | \n";
echo "".$Row["Events"]." | \n";
}
echo " ";
echo "
";
echo " | ";
echo " \n";
}
echo " ";
?>
|
|
|