$DB="basket";
$Connection = MySQL_Connect("localhost","jiskra","mkjd85246");
MySQL_Select_DB($DB);
if (!$Connection):
echo "nepodarilo se pripojit \n";
break;
endif;
require("actual_year.php");
$soubor_komentare="basket_komentare_".$r;
$i=1;
@$zaznam=MySQL_DB_Query("$DB", "SELECT * FROM $soubor_komentare WHERE Cislo=$cislo", $Connection);
while ($vypis = MySQL_Fetch_Array($zaznam)):
$akce_d=intval(SubStr($vypis["Datum"],8,2));
$akce_m=intval(SubStr($vypis["Datum"],5,2));
$akce_y=intval(SubStr($vypis["Datum"],0,4));
?>
echo $vypis["Kategorie"]."\n
";?>
echo $vypis["Domaci"]." vs. ".$vypis["Hoste"]."\n
";
?>
if ($vypis["Score_d"]<>"" && $vypis["Score_h"]<>""):
echo $vypis["Score_d"].":".$vypis["Score_h"];
if ($vypis["Score_q1d"]<>"" && $vypis["Score_q1h"]<>"" &&
$vypis["Score_q2d"]<>"" && $vypis["Score_q2h"]<>"" &&
$vypis["Score_q3d"]<>"" && $vypis["Score_q3h"]<>""):
echo " (".
$vypis["Score_q1d"].":".$vypis["Score_q1h"].", ".
$vypis["Score_q2d"].":".$vypis["Score_q2h"].", ".
$vypis["Score_q3d"].":".$vypis["Score_q3h"];
if ($vypis["Score_overtimed"]<>"" || $vypis["Score_overtimeh"]<>"")
echo ", ".$vypis["Score_overtimed"].":".$vypis["Score_overtimeh"];
echo ")\n
";
endif;
endif;?>
if ($vypis["Komentar"]==""):
echo "Utkání je bez komentáře";
else:
echo $akce_d.".".$akce_m.".".$akce_y." ".$vypis["Jmeno"]." - ";?>
echo NL2BR($vypis["Komentar"])."\n
\n
";
echo NL2BR($vypis["Statistika"])."\n
\n
";
endif;
endwhile;
MySQL_Close($Connection);
?>