how to do connectivity of 2 dbs in PHP script?

Question Posted / archi patel

3 Answers
10336 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to do connectivity of 2 dbs in PHP script?..

If you are trying to open multiple, separate MySQL
connections with the same MySQL user, password, and
hostname, you must set $new_link = TRUE to prevent
mysql_connect from using an existing connection.
The workaround is to require that the second MySQL
connection is new:

$db1 = mysql_connect($dbhost, $dbuser, $dbpass);
$rv = mysql_select_db($dbname1, $db1);
$db2 = mysql_connect($dbhost, $dbuser, $dbpass, TRUE);
$rv = mysql_select_db($dbname2, $db2);
Source: http://jp2.php.net/manual/en/function.mysql-connect.php
Message from: arithmetric at gmail dot com
26-Mar-2008 03:59

Is This Answer Correct ?

16 Yes

0 No

how to do connectivity of 2 dbs in PHP script?..

Answer / naveen das

Simple using two connection objects

Is This Answer Correct ?

3 Yes

0 No

how to do connectivity of 2 dbs in PHP script?..

Answer / manjunath

mysql_query("select db names");

Is This Answer Correct ?

0 Yes

6 No

Post New Answer