multiple database select

[vssp]

Hi friends

In my application i need to connect multiple database.First i connect one database and got the value then i connect another database to insert the values . If any possible to two database to connect single application .

Please send me your suggestion .


Thanks
vssp

[iam_clint]

depends on the application and language its written in.

[ronverdonk]

Following is a quote from an entry in the php.net documentation for mysql_select_db:

matsko at rogers dot com 10-May-2006 09:19
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,$pass);
$dbh2 = mysql_pconnect($host,$user,$pass);

You could do this...

mysql_query("USE database1",$dbh1);
mysql_query("Use database2",$dbh2);

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("SELECT * FROM database1.table",$dbh1);
mysql_query("SELECT * FROM database2.table",$dbh2);

Ronald :cool:

[vssp]

Thanks friends