\n";
break;
}
MySQL_Select_DB("rodos");
@$vysledek=MySQL_Query("SELECT * FROM seminare ORDER BY termin DESC");
if(!$vysledek):
echo "
\n";
break;
endif;
echo "
\n";
echo "\n";
echo "| \n";
echo "Název\n";
echo "\n";
echo " | \n";
echo "\n";
echo "Vzdělávací akce je určena pro\n";
echo "\n";
echo " | \n";
echo "\n";
echo "Místo a datum, doba konání\n";
echo "\n";
echo " | \n";
echo "\n";
echo "Cena kurzu\n";
echo "\n";
echo " | \n";
echo "\n";
echo "Počet účastníků\n";
echo "\n";
echo " | \n";
echo "
\n";
$i = 0;
$j = 0;
while ($zaznam = MySQL_Fetch_Array($vysledek))
{
$i = $i + 1; //pocitadlo zaznamu
if ($j == 0) //nastavuje barvu radku v tabulce
{
$barva = $b1;
$barvaR = "#DD0000";
$barvaG = "#00DD00";
$j = 1;
}
else
{
$barva = $b2;
$barvaR = "#FF0000";
$barvaG = "#00FF00";
$j = 0;
}
echo "\n";
if ($orderby == "seminare.nazev")
{
echo "| | \n";
}
echo "\n";
echo "";
echo $zaznam["nazev"];
echo "\n";
echo " | \n";
if ($orderby == "seminare.urcen")
{
echo " | \n";
}
echo "\n";
echo "";
echo $zaznam["urcen"];
echo "\n";
echo " | \n";
if ($orderby == "seminare.misto")
{
echo " | \n";
}
echo "\n";
echo "";
echo $zaznam["misto"];
echo ";";
echo "";
echo $zaznam["termin"];
echo "";
echo "\n";
echo " | \n";
if ($orderby == "seminare.cena")
{
echo " | \n";
}
echo "\n";
echo "";
echo $zaznam["cena"];
echo "\n";
echo " | \n";
if ($orderby == "seminare.pocet")
{
echo " | \n";
}
echo "\n";
echo "";
echo $zaznam["pocet"];
echo "\n";
echo " | \n";
echo "
\n";
}
$barva = "#00FFFF";
echo "\n";
echo "| \n";
echo "".PocetZaznamu($i)."\n";
echo " | \n";
echo "
\n";
echo "
\n";
MySQL_Close($spojeni);
echo "
