- Beranda
- Programmer Forum
Tulong Gan,,PHP or MYSql
...
TS
ichiruers
Tulong Gan,,PHP or MYSql
ane ada error ini gan,,, ,
setelah ane cek kgk ada gan.. .
Code:
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
setelah ane cek kgk ada gan.. .
Code:
<?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);
?>
0
723
3
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Mari bergabung, dapatkan informasi dan teman baru!
Programmer Forum
20.2KThread•4.3KAnggota
Urutkan
Terlama
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru