session_start();
include_once("../../../../mysql_connect.php");
$miasto = 'Zielona Góra';
$rok = 2013;
include('sedziowie2_mini.php');
$table_name = "refereeform";
$sql = "SELECT * FROM $table_name WHERE `miasto` = \"$miasto\" and `rok` = \"$rok\" ORDER BY `kraj`";
$result = @mysql_query($sql,$dbc)or die("Wykonanie zapytania nie powiodło się.");
$lista = "
No | Referee | ↓ Country | Age | Referee class | Status | Confirmed |
|
";
$ile =0;
$dzisiaj = date("d.m.Y");
$table_name = "flagi";
$sql = "SELECT * FROM $table_name ORDER BY id asc";
$result2 = @mysql_query($sql,$dbc)or die("Wykonanie zapytania nie powiodło się.");
$liczba_rekordow = mysql_num_rows($result);
$dane = array();
$x=0;
$flaga = "brak.gif";
while ($wiersz2 = mysql_fetch_array($result2)) {
$dane['panstwo_en'][$x] = $wiersz2['panstwo_en'];
$dane['panstwo_pl'][$x] = $wiersz2['panstwo_pl'];
$dane['flaga'][$x] = $wiersz2['plik'];
$x++;
}
while ($wiersz = mysql_fetch_array($result)) {
$id = $wiersz['id'];
$ile++;
$nazwisko = $wiersz['nazwisko'];
$imie = $wiersz['imie'];
$kraj = $wiersz['kraj'];
$kraj_p = str_replace(" 1", "", $kraj);
$kraj_p = str_replace(" 2", "", $kraj_p);
$kraj_p = str_replace(" 3", "", $kraj_p);
for ($a=0;$a<$x;$a++){if ($dane['panstwo_en'][$a]==$kraj_p or $dane['panstwo_pl'][$a]==$kraj_p) {$flaga = $dane['flaga'][$a]; break;}}
//for ($a=0;$a<$x;$a++){if ($dane['panstwo_en'][$a]==$kraj or $dane['panstwo_pl'][$a]==$kraj) {$flaga = $dane['flaga'][$a]; break;}}
$lat = wiek($wiersz['data_urodzenia']);
$sedzia = $wiersz['sedzia'];
$photo = $wiersz['photo'];
$status = $wiersz['status'];
$accepted = $wiersz['accepted'];
if ($wiersz['id2']){ $idz = $wiersz['id2']; } else { $idz = '1293'; }
If ($status == '1') {
$status_s = "Completed";
} else {
$status_s = "NOT Completed";
}
If ($accepted == '1') {
$accepted_s = "Ok";
} else {
$accepted_s = "TBC";
}
$lista .= "$ile | $imie $nazwisko | $kraj
| $lat | $sedzia | $status_s | $accepted_s |
";
}
?>
Referees List
|
EUROPEAN BILLIARDS & SNOOKER ASSOCIATION
6 reds qualification
02nd June 2013 - Zielona Góra/Poland
Referees List
|
echo "$lista"; ?>
|
|
|
© EBSA 2013 All rights reserved. Created by :
|