You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'tki_passpor LIKE '%AM 79008%' order by tki_nama,ukom_tgldaftar LIMIT 0,10' at line 1

<?php

 }

 

 if(isset($_POST['Search'])=="Tampilkan"){

 $b ="";

 //if(isset($_POST['tampil'])=="Tampilkan"){

 $namactki = $_POST['namactki'];

 $passpor = $_POST['passpor'];

 

 //$t="SELECT * FROM db_master_tki WHERE log_wilayah= '".$_SESSION['userid']."' $b";

 $t="SELECT * FROM db_master_tki WHERE";

 if($namactki !=""){

 $t .= " tki_nama = '$namactki'";

}

if($passpor !=""){

$t .= " tki_passpor LIKE '%$passpor%'";

}

 $limit2 = " order by tki_nama,ukom_tgldaftar LIMIT $StartRow,$PageSize";

 

 //echo $t.'<br >';

 $u= mysql_query($t.$limit2)or die(mysql_error());



 $queryc = mysql_query($t)or die(mysql_error());

 $total = mysql_num_rows($queryc);

?>