session_start();
include_once("../../../../mysql_connect.php");
function wiek($t) {$t = explode("-",$t); $y = (int) $t[0]; $m = (int) $t[1]; $d = (int) $t[2]; $wiek = date(Y) - $y; if ((date(m) < $m) || (date(m) == $m && date(d) < $d)) { $wiek--; } if ($wiek > 120) $wiek = '?'; return $wiek; }
$turniej = '6r';
$rok = '2013';
include('zawodnicy_mini.php');
$table_name = "entryform";
$sql = "SELECT * FROM $table_name WHERE `turniej` = \"$turniej\" and `rok` = \"$rok\" ORDER BY `kraj`";
$result = @mysql_query($sql,$dbc)or die("Wykonanie zapytania nie powiodo si.");
$lista = "
No | Player | ↓ Country | Age | Competition Break | Practice Break | Status |
|
";
$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 powiodo 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']);
$break_tur = $wiersz['break_tur'];
$break_tre = $wiersz['break_tre'];
$photo = $wiersz['photo'];
$status = $wiersz['status'];
if ($wiersz['id2']){ $idz = $wiersz['id2']; } else { $idz = '1293'; }
If ($status == '1') {
$status_s = "Confirmed";
} else {
$status_s = "NOT Confirmed";
}
$lista .= "$ile | $imie $nazwisko | $kraj
| $lat | $break_tur | $break_tre | $status_s |
";
}
?>
U21 Player List
|
EUROPEAN BILLIARDS & SNOOKER ASSOCIATION
6 reds qualification
02nd June 2013 - Zielona Góra/Poland
6 reds Player List
|
echo "$lista"; ?>
|
|
|
© EBSA 2013 All rights reserved. Created by :
|