2 connections problem

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 375,172 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,135 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MySQL advertiser:

Thread Tools Display Modes

Views: 947 | Replies: 1

•

Join Date: Jul 2006

Posts: 4

Reputation: milliondollar is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

milliondollar milliondollar is offline

Offline

Newbie Poster

2 connections problem

Jul 22nd, 2006

I create 2 connectionsand then try to select the current active database:

Help with Code Tags

(Toggle Plain Text)

$aaa_link = mysql_connect("host1","user1","pass1") or die(mysql_error());
$bbb_link = mysql_connect("host2","user2","pass2")or die(mysql_error());
 
mysql_select_db("dbname1", $aaa_link) or die(mysql_error());

However, mysql_select_db fails with error:

Help with Code Tags

(Toggle Plain Text)

Access denied for user: "user2" to database "dbname1"

What is wrong here?

http://www.milliondollarhosting.net
Cheap hosting plans with bunch of Disk Space and Data Transfer. Best solution for Game Hosting, Image Hosting, Flash Hosting and Video Hosting. Low cost domain registration and affordable Linux, PHP, MySQL web hosting.

•

Join Date: Jul 2006

Posts: 4

Reputation: milliondollar is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

milliondollar milliondollar is offline

Offline

Newbie Poster

Re: 2 connections problem

Jul 22nd, 2006

Sorry, mistake - host1 = host2, but users, passwords and dbnames there are different. By the way the next code worked perfectly:
$aaa_link = mysql_connect("host1","user1","pass1") or die(mysql_error());
mysql_select_db("dbname1", $aaa_link) or die(mysql_error());
That is the bbb_link's line that caused this problem for some reason. It appears as if after the second mysql_connect the mysql tries to work on the $bbb_link database and ignores the existence of $aaa_link.