Klub: $club[name]";
echo "";
$dotaz=mysql_query($sql)or die(" :".mysql_error());
if(mysql_affected_rows()){
$dotaz2=mysql_query("select c.position,c.score from kr_classification c
left join kr_contesttype ct on ct.id=c.id_contesttype
left join kr_contest cnt on cnt.id_contesttype=ct.id
where cnt.id='$_GET[contest]' ")or die(" :".mysql_error());
while($bod=mysql_fetch_assoc($dotaz2)){
switch ($bod['position']){
case 1: $zlato=$bod['score'];break;
case 2: $stribro=$bod['score'];break;
case 3: $bronz=$bod['score'];break;
case 4: $ctvrty=$bod['score'];break;
case 5: $paty=$bod['score'];break;
case 6: $sesty=$bod['score'];break;
case 7: $sedmy=$bod['score'];break;
case 8: $osmy=$bod['score'];break;
}
}
echo "\n";
echo"| Jméno |
Příjmení/Team |
Pozice |
Kategorie |
Bodů |
|---|
\n";
while ($row=mysql_fetch_assoc($dotaz)){
static $count=0;
static $sum=0;
switch ($row['position']){
case 1: $body=$zlato;break;
case 2: $body=$stribro;break;
case 3: $body=$bronz;break;
case 4: $body=$ctvrty;break;
case 5: $body=$paty;break;
case 6: $body=$sesty;break;
case 7: $body=$sedmy;break;
case 8: $body=$osmy;break;
}
echo "\n";
echo "\t| $row[firstname] | \n
\t$row[lastname]$row[teamname] | \n
\t$row[position] | \n
\t$row[event_cz] | \n
\t$body | \n
\n";
++$count;
$sum+=$body;
}
echo "| Celkem: | $sum |
";
echo "
\n";
}
}
else echo "Bohužel zadaná adresa nebyla nalezena
";
include "../menu/footer.php";?>