results from 2 servers?

[v3nt]

mmm - these work on independent scripts but when i try the 2 dbs on the same script they don't work?!

Anyone know how i might be able to get this working?

$host = "localhost";
$user = "a";
$pass = "a";
$db1 = "a";

$hostB = "b";
$userB = "b";
$passB = "b";
$db2 = "b";

$connection_l = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
mysql_select_db($db1) or die ("Unable to select database!");

$connection_2 = mysql_connect($hostB, $userB, $passB) or die ("Unable to connect!");
mysql_select_db($db2) or die ("Unable to select database!");

$result = mysql_list_tables($db1);


 while ($row = mysql_fetch_row($result)) {
	echo "<BR>Table: $row[0]\n";

$resultb = mysql_query("SHOW COLUMNS FROM $row[0]");

if(!$resultb) {
	 echo 'Could not run query: ' . mysql_error(); 
	 exit;
 } 

 if (mysql_num_rows($resultb) > 0) {

	 while ($row = mysql_fetch_assoc($resultb)) {
		 print_r($row);
		  echo "<BR>";
	 }
 }


 }

thanks in advance! D.

[bradgrafelman]

What do you mean by they "don't work"?

One thing I might suggest is that since you appear to have a true need for simultaneous SQL connections is that you utilize the connection resource parameter for each MySQL function. E.g. this:

mysql_select_db($db1);

would change to:

mysql_select_db($db1, $connection_1);

That way for each MySQL function PHP executes, but it (and you, the coder) know exactly which connection is being used.

[v3nt]

hello brad - thanks for the help.

I had already tried that and it doesn't work. In fact the file wont work at all if i have;

$connection2 = mysql_connect($hostB, $userB, $pass😎 or die ("Unable to connect!");
mysql_select_db($db2) or die ("Unable to select database!");

in the script. It gives this error;

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/modernactivity.co.uk/httpdocs/tests/dbs/multipleDatabases.php on line 23

which is this line;
while ($row = mysql_fetch_row($result)) { ...

it work if i delete one connection and set the result to
$result = mysql_list_tables($db2);

so it seem like it just has problems with having 2 connections? Any ideas?

dan.

[bradgrafelman]

v3nt wrote:

Any ideas?

Erm, yeah... the one I mentioned above: pass the correct connection resource (either $connection_1 or $connection_2) to each MySQL command so that PHP knows which connection to use.

[Drakla]

I remember this problem cropping up on The A Team and Mr. T says to Murdock "You wouldn't be havin no problem like this if you used classes for your database connections, sucka."

[v3nt]

sorry - got rid of that error.
was putting $db1, $connection_1 in the mysql_list_tables().

and how does its work when it comes down to;

$result = mysql_list_tables($dbA, $db😎; // ($connectionA, $connection😎

?

and is the below code correct as far as you can tell?

$host = "localhost";
$user = "";
$pass = "";
$dbA = "";

$connectionA = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
mysql_select_db($dbA, $connectionA) or die ("Unable to select database!");

$hostB = "";
$userB = "";
$passB = "";
$dbB = "";

$connectionB = mysql_connect($hostB, $userB, $passB) or die ("Unable to connect!");
mysql_select_db($dbB, $connectionB) or die ("Unable to select database!");

$result = mysql_list_tables($dbA, $dbB);


while ($row = mysql_fetch_row($result)) {
	echo "<BR>Table: $row[0]\n";

$resultb = mysql_query("SHOW COLUMNS FROM $row[0]");

if(!$resultb) {
	 echo 'Could not run query: ' . mysql_error(); 
	 exit;
 } 

 if (mysql_num_rows($resultb) > 0) {

	 while ($row = mysql_fetch_assoc($resultb)) {
		 print_r($row);
		  echo "<BR>";
	 }
 }


 }

many thanks. D.

[bradgrafelman]

First problem I see is with your use of [man]mysql_list_tables/man. I don't quite understand what you're attempted implementation is... have a quick read over the manual page for that function and see if you can't clarify/fix up that part of the code.

[v3nt]

i'm trying to list the tables and fields from a db.

this works fine without the 2 db connections. And i've used it a dozen times before.

i think the problem lies more in the connection part?

nesides the table issue is;

$connectionA = mysql_connect($host, $user, $pass) or die ("Unable to connect!"); 
mysql_select_db($dbA, $connectionA) or die ("Unable to select database!"); 

$connectionB = mysql_connect($hostB, $userB, $passB) or die ("Unable to connect!"); 
mysql_select_db($dbB, $connectionB) or die ("Unable to select database!"); 

correct as far as you can tell?

[bradgrafelman]

Yes, that part is correct. As I said, your use of [man]mysql_list_tables/man is incorrect. As the manual points out, it expects a database name as the first parameter, and a connection resource as the second parameter (if needed, such as in the case of multiple connections). This implies that the function is only applicable with a single database on a specific connection.

Thus, if you want to list the tables from both databases, you need to make two separate calls for this function, one for each database.

[v3nt]

ok - cheers brad. Will rethink this script a bit!

best, D.