Multiple Databases/Servers

Thom_Redhat

Am trying to use 3 differnet databases/servers inside a function! And it keeps giving:-

Warning: Supplied argument is not a valid MySQL result resource

This is because its trying to locate the table on the wrong database connection & is using the last open'ed database connection, but i cannot get it to use the other database connections, it just ignoires them!

i do a $query = mysql_query($summat, $db_connection);
and that has worked fine in lots of other pages its just because am using a function its erroring has anyone got around this...? or any advice...

Thanx!!

Natty_Dreadlock

i think the mysql api only supports one active connection so u gotta place every query after u closed the previous db connection and openened the new one - i guess that's the only way to do what u want.
hth

Thom_Redhat

The below example would fail, and i don't understand why?

Any ideas?

$db = mysql_connect("lala", "lala", "lala"); mysql_select_db("ula",$db);

$db2 = mysql_connect("lala", "lala", "lala"); mysql_select_db("ula",$db2);

function one() {
$sql = "sql stuff";
$result = mysql_query($sql, $db);

}

function two() {
$sql2 = "sql stuff";
$result2 = mysql_query($sql2, $db2);

}
[ code here that calls both functions ]

mysql_close($db);
mysql_close($db2);

Schwarzwald

I'm not sure on the MySQL only supporting one connection at a time (I'd have to look into manuals - I'm way too tired).

However, you have a problem with your functions - you don't actually have a connection to use inside them! When you have mysql_query($sql,$db) in the function, you either need to declare "global $db;" inside the funciton, or pass the connection as an argument to the function.

I suck at explaining, so here's an example:

function dbquery($query,$conn_id) {
  $result = mysql_query($query,$conn_id);
  return $result;
}

or, using globals (which is generally frowned upon):

function dbquery($query) {
  global $conn_id;
  $result = mysql_query($query,$conn_id);
  return $result;
}

I think that's it, at least.

Natty_Dreadlock

i think he's rigth, maybe there's another problem: Although php does support more than one mysql connection simultaneously (i got the wrong information from some text i read one year ago...), there's a php.ini setting that can limit the number of connections: mysql.max_links - perhaps yoour provider set this to 1 or whatever... just a hint if Schwarzwald's solution does not work.
hth