Re: [ITCENTER] Select semua tabel didatabase mysql [solved]

2007-01-31 Terurut Topik tito surya wardhana 
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]nbsp;nbsp;ff$list[$field2]nbsp;nbsp;$typebr;
 } 
}
?

  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/

[ITCENTER] Select semua tabel didatabase mysql

2007-01-29 Terurut Topik tito surya wardhana 
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]



-- 
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/

Re: [ITCENTER] Select semua tabel didatabase mysql

2007-01-29 Terurut Topik Danny Eka 
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]



-- 
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/