can use more than one databases?

[qadeer_ahmad]

Hi,

i have to use two database in one script file like this..

make database $link ...
<?
$link = mysql_connect ($MySQL_Hostname, $MySQL_Username, $MySQL_Password)

    or die ("Nu se poate face conexiunea la serverul MySQL");

mysql_select_db ($MySQLDatabasename1);

?>
//////// use $link like this.

<?
$query="Select * from tblpay where txn_id='".$txn_id2."'";
$rquery=mysql_query($query)or die("Can not Sellect all from tblpay");
$qrow=mysql_fetch_array($rquery);
?>

// now in a if condition i need another database

<?
$link2 = mysql_connect ($MySQL_Hostname, $MySQL_Username, $MySQL_Password)

    or die ("Nu se poate face conexiunea la serverul MySQL");

mysql_select_db ($MySQLDatabasename2);

?>

// can this work here and also after this i again required to use $link . Is i hava to make again $link ....

Please someone guid me.

[tsinka]

Hi,

in this case the second mysql_select_db call will mess up the first link. You can add a fourth parameter to mysql_connect to force PHP to open a completely new link to the second database:

 $link = mysql_connect ($MySQL_Hostname, $MySQL_Username, $MySQL_Password,true) ;

$link2 = mysql_connect ($MySQL_Hostname, $MySQL_Username, $MySQL_Password,true) ;

Alternatively, specify the database in your queries, like e.g.:

$query="Select * from ".$MySQLDatabasename1.".tblpay where txn_id='".$txn_id2."'";

Thomas

[Weedpacket]

You can also use the second argument to [man]mysql_select_db[/man] to specify which link is supposed to select the db.

[qadeer_ahmad]

working nicely.