Filter Tabel

   <script>
            $(document).ready(function() {
                // create DatePicker from input HTML element
                $("#datepickerAwal").kendoDatePicker({
                    format: "yyyy-MM-dd"
                });
                $("#datepickerAkhir").kendoDatePicker({
                    format: "yyyy-MM-dd"
                });
            });
    </script>

<script language="javascript">
function validasi(form){

  if (form.datepickerAwal.value == ""){
    alert("Anda belum memilih tanggal awal");
    return (false);
  }
  if (form.datepickerAkhir.value == ""){
    alert("Anda belum memilih tanggal akhir");
    return (false);
  }
  return (true);
}
</script>


<?php
include "config/koneksi.php";
$WaktuIndo      = date("d-m-Y");
$WaktuDB        = date("Y-m-d");
$TanggalAtas    = date("Y-m-d", mktime(0, 0, 0, intval(date('m')), intval(date('d'))+7, intval(date('Y'))));
?>
<img src="images/jadwal.png" width="181" height="39" />

<form name="jadwal" action="<?php echo $PHP_SELF;?>" method="POST" onSubmit="return validasi(this)">
<div style="font-family:Tahoma, Geneva, sans-serif;font-size:12px;">
<input id="datepickerAwal" value="" style="width:150px;" />&nbsp;Sampai Dengan&nbsp;<input id="datepickerAkhir" value="" style="width:150px;" />&nbsp;
<button type="submit" class="k-button">Proses</button></div>
</form>
<br />
<table style="font-size:13px;font-family:Tahoma, Geneva, sans-serif;border-left:solid #CCC 1px;border-right:solid #CCC 1px;" width="100%" cellpadding="1" cellspacing="0">
<tr align="center" >
 <td bgcolor="#FFFF99" width="26">No</td>
 <td bgcolor="#FF4A4A" width="119">Hari</td>
 <td bgcolor="#0099FF" width="132">Tanggal</td>
 <td bgcolor="#FFFF00" width="126">Jam Tayang</td>
 <td bgcolor="#6633CC" width="115">Status</td>
 <td bgcolor="#CC6699" width="267">Judul</td>
 <td bgcolor="#00CC66" width="280">Episode</td>
</tr>
<?php
 if(isset($_POST['datepickerAwal']) && isset($_POST['datepickerAkhir'])){
    $Awal        = $_POST['datepickerAwal'];
    $Akhir       = $_POST['datepickerAkhir'];

    $query  = "SELECT * FROM asn where tanggal >='".$Awal."' and tanggal <= '".$Akhir."'";
    echo $query;
    require_once("config/pagging.inc.php");
    $pg = new Pagging("modules.php?Jadwal-ASN");
    $pg->totalRecordPage = 10;
    $pg->setSQL($query);
 }else{
        $query  = "SELECT * FROM asn where tanggal >='2012-06-01' and tanggal <= '".$TanggalAtas."'";
        echo $query;
        require_once("config/pagging.inc.php");
        $pg = new Pagging("modules.php?Jadwal-ASN");
        $pg->totalRecordPage = 10;
        $pg->setSQL($query);
 }



 foreach($pg->data as $hsl) {
 $hari          = $hsl['hari'];
 $tanggal       = $hsl['tanggal'];
 $tayang        = $hsl['tayang'];
 $status        = $hsl['status'];
 $judul         = $hsl['judul'];
 $episode       = $hsl['episode'];
 ?>
<tr align="center">
<td style="border-bottom:#CCCCCC solid 1px;">        <?=++$pg->indexNumber ?>.</td>
<td style="border-bottom:#CCCCCC solid 1px;">        <?=$hari?> </td>
<td style="border-bottom:#CCCCCC solid 1px;">        <?=$tanggal?> </td>
<td style="border-bottom:#CCCCCC solid 1px;">       <?=$tayang?></td>
<td style="border-bottom:#CCCCCC solid 1px;">       <?=$status?></td>
<td style="border-bottom:#CCCCCC solid 1px;">        <?=$judul?></td>
<td style="border-bottom:#CCCCCC solid 1px;">        <?=$episode?></td>
</tr>       <?  } ?>

</table>