tes cari 2

<?
include "../koneksi.php";
//form dahulu
?>
<form action="cari_coba.php" method="post" name="postform">
<table width="435" border="0">
  <tr>
    <td width="112"><label for="TGL">Tanggal</label></td>
    <td width="5">:</td>
    <td width="304"><input type="text" name="TGL" id="TGL" maxlength="15" size="15"/>
      <img src="images2/cal.gif" alt="" height="18" style="cursor:pointer" onclick="javascript:NewCssCal('TGL','yyyyMMdd')"/></td>
  </tr>

  <tr>
    <td>&nbsp;</td>
    <td colspan="2">&nbsp;</td>
  </tr>

  <tr>
    <td><input type="submit" value="Tampilkan Data" name="cari" /></td>
    <td colspan="2">&nbsp;</td>
  </tr>
</table>
</form>

<?php
//di proses jika sudah klik tombol cari
if(isset($_POST['cari']))
{

/* tes apa aja variable yg dipanggil
    echo '<pre>';print_r($_POST);echo '</pre>';

*/

//===========PASTIKAN VARIABLE yg dikasi valid
    $tanggal=date('Y-m-d', strtotime($_POST['TGL']);
//kamu harus pastikan itu tanggalnya

//===========IF berdasarkan tanggal
    if(empty($tanggal)){
        $sql="select * from td_plg";
    }else{
        $sql="SELECT d.NO_KSR,c.ID_PEL, b.NM, c.TRIF_BR, c.DY_BR, c.GARDU, c.TIANG, c.NO_METER, b.KET from t_tim a, tm_plg b, td_plg c, t_kasir d where a.C_TIM=b.C_TIM and b.KTP=b.KTP and c.ID_PEL=b.ID_PEL and b.STATUS_KSR=1 and b.NO_KSR=d.NO_KSR and TGL='$TGL'";
    }
//====PASTIKAN BENTUKNYA SAMA.. jangan satu di query.. satu cuma nama
    echo $sql; //coba tes apakah querynya benar/ salah di phpmyadmin
}