[syntax="php"]<?
include("config.inc.php");
echo'<link rel="stylesheet" type="text/css" href="style.css">';
$letterArray = array("D","V","M","A","S");
echo "<center>[<a href='".$PHP_SELF."?pos=D'>Doel</a>
<a href='".$PHP_SELF."?pos=V'>Verdediging</a>
<a href='".$PHP_SELF."?pos=M'>Middenveld</a>
<a href='".$PHP_SELF."?pos=A'>Aanval</a>
]<br></center>
<hr width='35%' align='center'><br><br>";
if(isset($_GET['pos']))
{
if(in_array($_GET['pos'],$letterArray))
{
$letter = $_GET['pos'];
}
else
{
exit;
}
if($letter == "V")
{
$positieResult = "Verdediging";
}
elseif($letter == "M")
{
$positieResult = "Middenveld";
}
elseif($letter == "A")
{
$positieResult = "Aanval";
}
elseif($letter == "S")
{
$positieResult = "Aanval";
}
elseif($letter == "D")
{
$positieResult = "Doel";
}
}
if(!$letter)
{
exit;
}
elseif($letter != "0-9")
{
$query = mysql_query("SELECT * FROM spelers WHERE positie LIKE '".$letter."%' ORDER BY positie ASC") or die (mysql_error());
}
else
{
$query = mysql_query("SELECT * FROM spelers WHERE positie LIKE '1%' OR naam LIKE '2%' OR naam LIKE '3%' OR naam LIKE '4%' OR naam LIKE '5%' OR naam LIKE '6%' OR naam LIKE '7%' OR naam LIKE '8%' OR naam LIKE '9%' ORDER BY positie ASC") or die (mysql_error());
}
echo "U heeft gekozen voor: <b>" . $positieResult . "</b><p><b>Resultaten:</b><hr>";
if(mysql_num_rows($query) == 0)
{
echo "Er zijn geen spelers gevonden met de positie: " . $positieResult . "</td>";
}
echo" <table border=\"1\" width=\"100%\" id=\"table1\">
<tr>
<td width=\"149\"><b>Naam</b></td>
<td width=\"171\"><b>Positie</b></td>
<td width=\"168\"><b>Geboortedatum</b></td>
<td><b>Club</b></td>
<td width=\"110\"><b>Nationaliteit</b></td>
</tr>";
while ($show = mysql_fetch_object($query))
{
echo "
<tr>
<td width=\"149\"><a href='speler.php?id=".$show->id."'>".$show->naam.", ".$show->achternaam."</td>
<td width=\"171\">".$show->naam."</td>
<td width=\"168\">".$show->geboortedatum."</td>
<td>".$show->club."</td>
<td width=\"110\"><img src=\"".$show->nationaliteit.".gif\"</img></td>
</tr>
";
}
echo'</table><br>';
?> [/syntax]
probeer dit eens volgens mij is hij zo goed