Pilih Kecamatan :
$quer2=mysql_query("SELECT DISTINCT kecamatan FROM $TNisn ORDER BY kecamatan ASC");
?>
echo "Select one ";
while($noticia2 = mysql_fetch_array($quer2)) {
$selected = ($_GET['cat']==$noticia2['kecamatan'])?$selected = "selected":$selected = "";
echo "{$noticia2['kecamatan']} "." ";
}
echo " ";
?>
Pilih Jenjang / Tingkatan:
$cat=$_GET['cat']; // This line is added to take care if your global variable is off
$cat3=$_GET['cat3'];
if(isset($cat) and strlen($cat) > 0){
$quer=mysql_query("SELECT * FROM $TNisn WHERE kecamatan = '$cat' ORDER BY jenjang ASC");
}else{$quer=mysql_query("SELECT DISTINCT jenjang FROM $TNisn");
}
?>
echo " Select one ";
while($noticia = mysql_fetch_array($quer)) {
$selected = ($cat3==$noticia['nisn'])?$selected = "selected":$selected = "";
echo "$noticia[jenjang] ";
}
echo " ";
?>
Pilih Penghasilan:
$cat=$_GET['cat']; // This line is added to take care if your global variable is off
$cat3=$_GET['cat3'];
$cat4=$_GET['cat4'];
if(isset($cat) and strlen($cat) > 0){
$quer=mysql_query("SELECT * FROM $TNisn WHERE jenjang = '$cat3' ORDER BY penghasilan ASC");
}else{$quer=mysql_query("SELECT DISTINCT penghasilan FROM $TNisn");
}
?>
echo " Select one ";
while($noticia = mysql_fetch_array($quer)) {
$selected = ($cat4==$notice['nisn'])?$selected = "selected":$selected = "";
echo "$notice[penghasilan] ";
}
echo " ";
?>