searchng

<h1 class="page-header"> <span class="glyphicon glyphicon-book"></span> &nbsp Daftar Nilai Ujian</h1>
   <div class="col-sm-offset-3 col-sm-8">
  <form class="navbar-form " action="" method="post" >
  <div class="form-group">
   <select class="form-control" name="sesi">
                                        <option> -- Try-Out Ke -- </option>
                                        <?php
                                        $sql ="SELECT DISTINCT sesi FROM  `tbl_nil_ujian` ";
                                        $query = mysql_query($sql);
                                        while($row = mysql_fetch_array($query)){
                                        ?>
                                                <option value="<?php echo $row[0]?>"><?php echo $row[0]?></option>
                                  <?php
                                        }
                                  ?>
        </select>
  </div>
   <div class="form-group">
   <select class="form-control" name="jurusan">
                                        <option> -- Jurusan -- </option>
                                        <?php
                                        $sql ="SELECT DISTINCT jurusan FROM  `tbl_siswa`  ";
                                        $query = mysql_query($sql);
                                        while($row = mysql_fetch_array($query)){
                                        ?>
                                                <option value="<?php echo $row[0]?>"><?php echo $row[0]?></option>
                                  <?php
                                        }
                                  ?>
        </select>
  </div>
  <div class="form-group">
   <select class="form-control" name="kelas">
                                        <option> -- Kelas -- </option>
                                        <?php
                                        $sql ="SELECT DISTINCT kelas FROM  `tbl_siswa` ";
                                        $query = mysql_query($sql);
                                        while($row = mysql_fetch_array($query)){
                                        ?>
                                                <option value="<?php echo $row[0]?>"><?php echo $row[0]?></option>
                                  <?php
                                        }
                                  ?>
        </select>
  </div>
  <button type="submit" name="submit" class="glyphicon glyphicon-search btn btn-primary btn-large"></button>
</form>
</div>
<br/><br/><br/><br/><br/><br/>

  <div class="row placeholders">
  <?php
     if(isset($_POST['submit'])){
        $jurusan        = $_POST['jurusan'];
        $kelas          = $_POST['kelas'];
        $sesi           = $_POST['sesi'];

    $sql1   = "SELECT COUNT( DISTINCT `id_siswa` ) FROM  `tbl_nil_ujian`  ";
    $query1 = mysql_query ($sql1);
    $row1   = mysql_fetch_array($query1);
    $id_sis = $row1[0];


    for ($x =1; $x <= $id_sis; $x++) {

        //$sql1 = "SELECT COUNT( DISTINCT  `sesi` ) FROM  `tbl_nil_ujian`";
        //$query1   = mysql_query ($sql1);
        //$row1     = mysql_fetch_array($query1);
        //$sesi = $row1[0];

    for ($y =$sesi; $y <= $sesi; $y++) {
    $sql4   = "SELECT * FROM  `tbl_nil_ujian` AS n LEFT JOIN  `tbl_siswa` AS s ON n.id_siswa = s.id_siswa WHERE  n.id_siswa ='$x' and `sesi`='$y' and `kelas` ='$kelas' ";
    $query4 =mysql_query($sql4);
    $row4   = mysql_fetch_array($query4);
?>
<button class=" btn btn-primary btn-large"> <?php echo $row4[9]?></button>
<span class="label label-info">Try-Out Ke <?php echo $y ?></span>
<table class="table table-striped  table-hover "  style="text-align:center;">
    <thead>
        <tr>
            <th class="col-sm-1"><center>No</center></th>
            <th class="col-sm-3"><center>Tangal Ujian</center></th>
            <th class="col-sm-2"><center>Mata Pelajaran</center></th>
            <th class="col-sm-2"><center>Nilai Ujian</center></th>
        </tr>
    </thead>
    <tbody>
<?php
    $sql    = "SELECT * FROM  `tbl_nil_ujian` AS n LEFT JOIN  `tbl_siswa` AS s ON n.id_siswa = s.id_siswa WHERE  n.id_siswa ='$x' and `sesi`='$y' and `kelas` ='$kelas' ";

    $query  =mysql_query($sql);

    $no=0;
    while($row=mysql_fetch_array($query)){
    $no++;
?>
    <tr>
        <td><?php echo $no;?></td>
        <td><?php echo $row[2]?></td>
        <td><?php echo $row[3]?></td>
        <td><?php echo $row[5]?></td>
    </tr>
<?php
}
?>
<tr class="info">
    <?php
        $sql2 ="SELECT AVG(  `hasil` ) FROM  `tbl_nil_ujian` AS n LEFT JOIN  `tbl_siswa` AS s ON n.id_siswa = s.id_siswa WHERE n.id_siswa ='$x' and `kelas` = '$kelas'";
        $query2 = mysql_query($sql2);
        $row2 = mysql_fetch_row($query2);
    ?>
        <td colspan="3">
            <center><strong>Jumlah</strong></center>
        </td>
        <td>
            <center><strong>
            <?php
            echo number_format($row2[0],1);
            ?>
            </strong></center>
        </td>
    </tr>
    </tbody>
    </table>
    <br/>
<?php
        }
    }
}
?>
  </div>