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/
