danis

<html><head><title>= DATABASE SISWA = Dinas Pendidikan Pemuda dan Olahraga Kota Surakarta = Solo the spirit of Java</title><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><script><!--// Secript scrolling Title Barvar repeat=1 // 1 untuk mengulang terus-menerus, 0 untuk satu kalivar title=document.titlevar leng=title.lengthvar start=1function titlemove() {  titl=title.substring(start, leng) + title.substring(0, start)  document.title=titl  start++  if (start==leng+1) {    start=0    if (repeat==0)    return  }  setTimeout("titlemove()",140)}if (document.title)titlemove()function MM_jumpMenu(targ,selObj,restore){ //v3.0  eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");  if (restore) selObj.selectedIndex=0;}//--></script><SCRIPT language=JavaScript>function reload(form){var val=form.cat.options[form.cat.options.selectedIndex].value; self.location='nyoba.php?cat=' + val ;}function reload3(form){var val=form.cat.options[form.cat.options.selectedIndex].value; var val2=form.subcat.options[form.subcat.options.selectedIndex].value; self.location='nyoba.php?cat=' + val + '&cat3=' + val2 ;}</script></head><body bgcolor="#2A1A63" leftmargin="0" topmargin="0" rightmargin="0" bottommargin="0" marginwidth="0" marginheight="0"><table width="760" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">  <!--DWLayoutTable-->  <tr>     <td width="760" height="200" valign="top">       <?php include "header.html"; ?>    </td>  </tr>  <tr>     <td height="149" valign="top"><table width="96%" border="0" align="center" cellpadding="0" cellspacing="0">        <tr>          <td>            <?require("konfigurasi.php");if ($SortOrder == ""){	$strSort = "nomor";}elseif ($SortOrder == "nomor"){	$strSort = "nomor";}elseif ($SortOrder == "nisn"){	$strSort = "nisn";}elseif ($SortOrder == "nama"){	$strSort = "nama";}elseif ($SortOrder == "sekolah"){	$strSort = "sekolah";}else{	$strSort = "nomor";}$strSQL = "SELECT * FROM $TNisn ORDER BY $strSort";$MyQuery = @mysql_query($strSQL, $conn) or die ("Pesan Error");?>            <br>			<form method=post name=f1 action=''>            <table width="100%" border="0" cellspacing="0" cellpadding="0">              <tr>                <td><table width="100%" border="0">                    <tr>                       <td width="234">Pilih Kecamatan : 		  <?$quer2=mysql_query("SELECT DISTINCT kecamatan FROM $TNisn ORDER BY kecamatan ASC"); ?><?echo "<select name='cat' onchange=\"reload(this.form)\"><option value=''>Select one</option>";while($noticia2 = mysql_fetch_array($quer2)) { if($noticia2['nisn']==@$cat){echo "<option selected value='$noticia2[nisn]'>$noticia2[kecamatan]</option>"."<BR>";}else{echo  "<option value='$noticia2[nisn]'>$noticia2[kecamatan]</option>";}}echo "</select>";?></td>                      <td width="254">Pilih Jenjang / Tingkatan: <?$cat=$HTTP_GET_VARS['cat']; // This line is added to take care if your global variable is offif(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 name=\"subcat\" onchange=\"reload3(this.form)\" ><option value=''>Select one</option>";while($noticia = mysql_fetch_array($quer)) { if($noticia['nisn']==@$cat3){echo "<option selected value='$noticia[nisn]'>$noticia[jenjang]</option>"."<BR>";}else{echo  "<option value='$noticia[nisn]'>$noticia[jenjang]</option>";}}echo "</select>";?></td>                      <td width="116" valign="middle"><input name="tampil" type="submit" id="tampil" value="Tampil" /></td>                      <td width="108">&nbsp;</td>                    </tr>                  </table></td>              </tr>            </table></form><br><table width="100%" border="0" cellpadding="0" cellspacing="0" bordercolor="#FF0000">  <tr bgcolor="#5E43BC">                <td width="9%"><strong><font color="#FFFFFF">No.</font></strong></td>                <td width="13%"><strong><font color="#FFFFFF">NISN</font></strong></td>                <td width="28%" height="30" bgcolor="#5E43BC"><strong><font color="#FFFFFF">Nama</font></strong></td>                <td width="31%"><strong><font color="#FFFFFF">Sekolah</font></strong></td>	<td width="19%"><div align="center"><strong><font color="#FFFFFF">Detail</font></strong></div></td>  </tr><?while ($row = mysql_fetch_array($MyQuery)){	if($no%2==0)	$warna="#FFFFFF";	else $warna="#F3F3F3";	echo "<tr bgcolor='$warna'>\n";    echo "<td width=\"5%\">" . $row["nomor"] . "</td>\n";    echo "<td width=\"26%\">" . $row["nisn"] . "</td>\n";    echo "<td width=\"34%\" height=\"30\">" . $row["nama"] . "</td>\n";    echo "<td width=\"20%\">" .$row["sekolah"] . "</td>\n";	echo "<td width=\"15%\"><input type=\"button\" value=\"Detail\" onClick=\"window.location.href='detail-siswa.php?ViewID=" . $row["id"] . "&Signature=" .md5($row["id"]) . "';\"></td>\n";  	echo "</tr>\n";$no=$no+1;					  }?><br> </table></td>        </tr>      </table></td>  </tr>  <tr>     <td height="50" valign="top"> <div align="center">         <?php include "footer.html"; ?>      </div></td>  </tr></table></body></html>