<?php
$arr = array();
$arr[Alles] = '*' ;
$arr[Een] = '1';
$arr[Twee] = '2';
$arr[Drie] = '3';
echo '<form action="" method="get">';
echo '<select name="id" onchange="this.form.submit();">';
foreach ($arr as $key => $value) {
echo '<option value="'.$value.'"';
if ($value == $_GET[id]){
echo 'selected';
}
echo '>'.$key.'</option>';
}
echo '</select>';
echo '</form>';
$sql="SELECT * FROM table WHERE id = $_GET[id] ";
$result=mysql_query($sql);
while($row = mysql_fetch_array($result)){
echo $row[naam].'</br>';
}
?>
de volgende regel geeft problemen:
$sql="SELECT * FROM table WHERE id = * ";
is zoiets wel mogelijk of dien ik dan 'WHERE id = *' weg te laten?