Rafanan, Charls - Rafanan, Charmyne
Team Dynamik, CBE
Evidované kluby:od: 23.09.2017 - Team Dynamik, CBE
od: 02.06.2018 - Team Dynamik
First record in database: echo $first_dt ?>
if (isset($_GET['id']) && $_GET['id'] !='')
$par_sut_id =$_GET['id'];
if (isset($_GET['rozdel']) && $_GET['rozdel'] !='')
$rozdel =$_GET['rozdel'];
else
$rozdel ='';
echo "";
if ($rozdel == 'SL')
echo " Concat STT & LAT ";
else
echo " Split STT & LAT";
echo "
";
$sql_str = "select a.pod_id, b.sutaz_id, a.nazov, a.dt_pod, b.druh,"
." b.sutaz, b.p_parov, c.umiestnenie_od, c.umiestnenie_do, c.nova_ktg, 'szts' as typ, b.s_l "
." from tis_podujatie a, tis_sutaze b, tis_vysledky c, tis_par_sutaz s"
." where s.par_sut_id = '".$_GET['id']."'"
." and s.par_sut_id = c.par_sut_id"
." and c.sutaz_id = b.sutaz_id"
." and b.pod_id = a.pod_id";
if ($rozdel == 'SL')
$sql_str .= " order by s_l DESC, dt_pod desc";
else
$sql_str .= " order by dt_pod desc";
//echo $sql_str;
$result2 = mysqli_query($link, $sql_str);
$num_sut = mysqli_Num_Rows($result2);
if ($num_sut!=0)
{
while($pary = MySQLi_Fetch_Array($result2))
{
$s_l = $pary['s_l'];
if (($rozdel == 'SL' && $s_l != $old_s_l) || $old_s_l =='')
{
if ($old_s_l != '')
{
echo "";
echo "";
echo ""; } echo "
Date | "; echo "Event | "; echo "Competition | "; echo "Type | "; echo "Couples | "; echo "Rank | "; echo ""; echo " | |
".$font_bold.skdatum($pary['dt_pod'])." | "; echo "".$img." | "; echo "".$font_bold."".$pary['nazov']." | "; echo "".$font_bold."".$pary['sutaz']." | "; echo "".$font_bold.$pary['druh']." | "; echo "".$font_bold.$pary['p_parov']." | "; echo "".$font_bold; if ($pary['umiestnenie_od'] < $pary['umiestnenie_do']) echo $pary['umiestnenie_od'] .". - ".$pary['umiestnenie_do']."."; else echo $pary['umiestnenie_od']."."; echo " | "; echo "".$font_bold.$pary['nova_ktg']." | "; echo "
No record found... | "; echo "