using 2 or 3 Databases in PHP!!!

[Tara83]

i'm having this project where i need to be connected to more than 1 database > i've used php before so any redirection to articles or tutorial would be helpful.

thnx for your time

[gubbachchi]

Hi,

You can just use the query in this way,

mysql_query = "SELECT * FROM database1.table 1,database2.tab le2,database3.t able3 WHERE id='1'";

With regards

[Tara83]

thnx for your reply

what about the config file? i still need a new statment to connect to 2 DB

[ronverdonk]

thnx for your reply

what about the config file? i still need a new statment to connect to 2 DB

See the following entry in the mysql_select_db chapter of the PHP manual
at multiple dbs

Just incase the mysql_select_db () function still won't work with multiple database connections (as has happened to me before).

$dbh1 = mysql_pconnect( $host,$user,$pa ss);
$dbh2 = mysql_pconnect( $host,$user,$pa ss);

You could do this...

mysql_query("US E database1",$dbh 1);
mysql_query("Us e database2",$dbh 2);

This does the same thing as the mysql_select_db () function...

or this...

You don't even have to select the database for each connection.

mysql_query("SE LECT * FROM database1.table ",$dbh1);
mysql_query("SE LECT * FROM database2.table ",$dbh2);

Ronald

[Tara83]

appreciate your fast help ronverdonk
thnx alot

[ronverdonk]

appreciate your fast help ronverdonk
thnx alot

You are welcome. See ya again.

Ronald