haloo

soalannya begini..

1: bole ke kita join 2 atau lebih tables antara 2 mysql databases dalam php?

contoh nya satu database untuk 'forum' dan satu lagi database utk 'article'...

atau

2: connect 2 mysql databases dalam masa dan page yang sama ..
adakah akan terjadinya error?..

dan

3: apa advantage and disadvantage antara kedua-dua di atas?
dan minta cadangan korang kalau ada cara yang lebih baik lagi..

Bole

1) SELECT * FROM database1.table1, database2.table2 WHERE table1.id=table2.id

2) tak

3) tak tau, hehehe. sape lagi berpengetahuan bagitau la

__________________
http://sidik.org/

ic.. terima kasih..

raser takder aper2...sebab itu hanya database sajer...tak kisah kalau nak kongsi berapa pun dalam satu page....cam kita kongsi 1 database untuk banyak field ler...i think there will be no error

__________________
" I love you as much as i know how "

ermmm raser takder aper2...sebab just guna lebih database jer...yerlah cam kita guna banyak field untuk satu database...i think there will be now error

__________________
" I love you as much as i know how "

oh.. sebab saya kira kalau nak pakai 2 database kena connect dua dua... so bila kita select table dia jadi pening nak select mana satu hehe.. jadi kalau ada dua table nama yang sama dalam 2 database tak ke dia pilih dua dua?..

camano lak tu?

okie, i might be able to answer your question.

if you are using php u can connect to both database at the same time in a single script.

You code as usual but when you are about to make a query to database A u do this.

then when you are about to query database B. Just call this method.
then u perform your query to it.
everything should work fine.

Also, take note, u have to connect to the mysql with mysql_connect('','','');

regarding your question 3, both has it advantage and disadvantages. As for first method your query will be definitely longer, while second method will be simplier and easier.
but if you are talking about efficiency then you'll have to test it by using a timer.

got it!! .. thanks vcheewei..

no problem.