cari

if ($_POST[materi]== NULL) {

$cari =mysql_query ("select * from plan where TGL_MULAI = '$_POST[tanggal]'");
echo "<table border=1>

    <tr><th>Kode Plan</th>
    <th>NAMA TRAINING</th>
    <th>LC</th><th>Instruktur</th>
    <th>Ubis</th><th>Angkatan</th>
    <th>Tanggal Mulai</th>
    <th>Tanggal akhir</th>
    <th>Anggaran</th>
    <th>Peserta</th></tr>";

$i=1;
while ($r=mysql_fetch_array($cari)){
   echo " <tr><td>$r[KODE_PLAN]</td><td>$r[NAMA_M_TRAINING]</td><td>$r[KODE_LC]</td><td>$r[KODE_INST]</td><td>$r[KODE_UBIS]</td><td>$r[ANGKATAN]</td><td>$r[TGL_MULAI]</td><td>$r[TGL_AKHIR]</td><td>$r[ANGGARAN]</td><td>$r[PST]</td></tr>";
   $i++;
}
echo "</table>";
}
else {
    $cari =mysql_query ("select * from plan where NAMA_M_TRAINING like '%' '$_POST[materi]''%'");
echo "<table border=1>

    <tr><th>Kode Plan</th>
    <th>NAMA TRAINING</th>
    <th>LC</th><th>Instruktur</th>
    <th>Ubis</th><th>Angkatan</th>
    <th>Tanggal Mulai</th>
    <th>Tanggal akhir</th>
    <th>Anggaran</th>
    <th>Peserta</th></tr>";

$i=1;
while ($r=mysql_fetch_array($cari)){
   echo " <tr><td>$r[KODE_PLAN]</td><td>$r[NAMA_M_TRAINING]</td><td>$r[KODE_LC]</td><td>$r[KODE_INST]</td><td>$r[KODE_UBIS]</td><td>$r[ANGKATAN]</td><td>$r[TGL_MULAI]</td><td>$r[TGL_AKHIR]</td><td>$r[ANGGARAN]</td><td>$r[PST]</td></tr>";
   $i++;
}
}