Terima kasih atas tanggapannya, saya akhirnya dpt dari milis php, kira2 seperti ini : <? mysql_connect("localhost","root",""); mysql_select_db("makarim"); $tabel=array("tb_books","tb_film"); for ($i=0;$i<=1;$i++){ if($tabel[$i]=='tb_books'){ $field1='title'; $field2='book_id'; $ff='title'; $type='buku'; }elseif($tabel[$i]=='tb_film'){ $field1='title_indonesia'; $field2='id_film'; $ff='title_indonesia'; $type='film'; } $query=mysql_query("select $field1,$field2 from $tabel[$i] where $ff like '%$keyword%'"); while($list=mysql_fetch_array($query)) { echo "dd$list[$field1] ff$list[$field2] $type<br>"; } } ?>
thanks semuanya, salam tito Danny Eka <[EMAIL PROTECTED]> wrote: Cobaiin ==> SELECT tabel1[.field1], tabel2[.field1], tabel3[.field3] FROM tabel1, tabel2, tabel3 WHERE tabel1[.field1] = 'kata yg dicari' OR tabel2[.field2] = 'kata yg dicari' OR tabel3[.field3] = 'kata yg dicari'. Fungsi utk execute query di PHP ===>mysql_query(). Klo salah mohon dimaafin...:P NB:[.field] ==> Optional aja 2007/1/29, tito surya wardhana <[EMAIL PROTECTED]>: > > Dear all, > mo tanya gimana caranya select kata dari semua tabel di database mysql > pakai php. contoh saya ada 3 tabel,nah di saya mo cari kata di semua tabel > tsb. gimana perintah select nya ? > > thanks > > tito > > --------------------------------- > Finding fabulous fares is fun. > Let Yahoo! FareChase search your favorite travel sites to find flight and > hotel bargains. > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed] --------------------------------- It's here! Your new message! Get new email alerts with the free Yahoo! Toolbar. [Non-text portions of this message have been removed] -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## ## Jaket ITCENTER tersedia di http://shop.itcenter.or.id Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ITCENTER/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/