$id = $_GET["id"];
$sql = "SELECT * FROM spelers WHERE id=$id";
$resultaat = mysql_query($sql) or die("Query mislukt: " . mysql_error());
while ($rij = mysql_fetch_assoc($resultaat)) {
$id = $rij['id'];
$naam = $rij["naam_spelers"];
$achternaam = $rij["achternaam_spelers"];
$nummer = $rij["nummer_spelers"];
$foto = $rij["foto_spelers"];
$positie = $rij["positie_spelers"];
$type = $rij["type_spelers"];
$special = $rij["special"];
$dir = 'spelers/';
if(isset($foto)) {
if(eregi('../', $foto) == FALSE) {
if(file_exists($dir.$foto)) {
$fotofinal = "spelers/$foto";
}
else {
$fotofinal = "template/noplayer.jpg";
}
}
else {
$url = 'index.php?page=error&error=14';
echo "";
}
}
else {
$url = 'index.php?page=error&error=15';
echo "";
}
if ($positie == '1') {
$pos = "Goalie";
}
elseif ($positie == '2') {
$pos = "Defender";
}
elseif ($positie == '3') {
$pos = "Forward";
}
else {
$pos = "Bench";
}
if ($type == '1') {
$typ = "Speler";
}
elseif ($type == '2') {
$typ = "Trainer";
}
elseif ($type == '3') {
$typ = "Begeleider";
}
elseif ($type == '4') {
$typ = "Coach";
}
else {
$typ = "Speler/Coach";
}
if ($nummer == '') {
$num = "";
}
elseif ($nummer == '0') {
$num = "";
}
else {
$num = "
Nummer:
$nummer
";
}
echo "
$naam $achternaam
";
}
?>