two mysql database connections

viveleroi0

I have one page that is trying to connect to two databases at once... but I cannot find any decent descriptiopn on how to do this... I find suggestions like "if you do that twice, the link identifier will be different, but it won't be either." That doesn't help at all.

Can anyone figure out why this causes errors:

$connection1 = mysql_connect($hostname, $username, $password);
$db1=mysql_select_db($data1,$connection1);
$db2=mysql_select_db($data2,$connection1);

$Query1="SELECT * FROM Carts";
$result=mysql_query($Query1,$db1);
$num=mysql_num_rows($result);

echo"$num";

bad76

beacause
select_db make a link beetween db and connection. You can't
assign two different link, the second take off the first.

you can try this

$connection1 = mysql_connect($hostname, $username, $password); 
$db1=mysql_select_db($data1,$connection1); 

$connection2 = mysql_connect($hostname, $username, $password); 
$db2=mysql_select_db($data2,$connection2); 


$Query1="SELECT * FROM Carts"; 
$result=mysql_query($Query1,$db1); 
$num=mysql_num_rows($result);

viveleroi0

I've tried every way I could find on the net, and nothing works.

This is what I get when I use the code above, I've gone through it several times to make sure it's correct

Warning: Supplied argument is not a valid MySQL-Link resource in /home/www/jazbot/php/Jazz/Shop/test.php on line 16

Warning: Supplied argument is not a valid MySQL result resource in /home/www/jazbot/php/Jazz/Shop/test.php on line 17

bad76

You need
to debug out some other information... try this:

$connection1 = mysql_connect($hostname, $username, $password) or die ("error 1:".mysql_error()); 
$db1=mysql_select_db($data1,$connection1) or die ("error 2:".mysql_error()); 
; 

$connection2 = mysql_connect($hostname, $username, $password) or die ("error 3:".mysql_error()); 
; 
$db2=mysql_select_db($data2,$connection2) or die ("error 4:".mysql_error()); 
;