soo.. i want to make filter function on my website that, he use 3 tables tb_data,tb_peserta, and paket to print out the tables component on yhis page
$keyword = $_POST['keyword'];
$query = "SELECT tb_peserta.id_peserta,tb_data.nama,tb_paket.nama_paket,ket,waktu_awal,waktu_akhir FROM tb_peserta,
tb_data,tb_paket WHERE tb_peserta.id_number=tb_data.id_number AND tb_peserta.id_paket = tb_paket.id_paket AND status_data_peserta='aktif' AND nama LIKE '%$keyword%' OR nama_paket LIKE '%$keyword%' OR ket LIKE '%$keyword'";
that is the filter query that ive made.. this not showing a data but it show all data, its not work.. so ineed ur help
Aucun commentaire:
Enregistrer un commentaire