how to do connectivity of 2 dbs in PHP script?
Answer Posted / lt
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 |
Post New Answer View All Answers
How to create a session? How to remove data from a session?
List the different types of print functions available in php?
What is if isset ($_ post submit )) in php?
How to upload file in php?
Are php session secure?
Which methods should be used for sending an email using the variables $to, $subject, and $body?
What is abstract class php?
What is php call function?
What is the use of array_search() in php?
What is the main difference between php 4 and php 5?
Does cors prevent csrf?
Tell me how can we define a variable accessible in functions of a php script?
Why do we use htaccess and where?
Is null or empty c#?
Give the case where we can use get and we can use post methods?