how to handle connecting to multiple DB's

[svoec]

ok -- I have 2 DB's -- one happens to be a VB database, the other is a homegrown membership db --

I am trying to run a little script that connects to both DB's and does some updates on the VB DB based on what is in membership DB.

but I'm running into problems doing it the way I think it would be easiest --

here is my code -- with some comments for the parts I'm having trouble with.

mysql_select_db($mm) or die("Can't select database");
$sql_query = mysql_query("select * from members where forum != ''") or die (mysql_error());
while ($nnn=mysql_fetch_row($sql_query)){

connect to VB-DB

update statment here}

If I can't get it to work this way -- then I have to read the info I want into several arrays, and close the first DB, then open the second--

Am I crazy?? or is there a way to do it the first way ??

Thanks!!

[superwormy]

The second parameter ( optional ) to mysql_query() is a resource result specifing which database connection to use.

$first_connect = mysql_connect ();
mysql_select_db ("database1", $first_connect);

$second_connect = mysql_connect ();
mysql_select_db ("database2", $second_connect);

mysql_query ("query for database one", $first_connect);

mysql_query ("query for databse two", $second_connect);

[svoec]

cool -- thanks --

I did figure out a way to do what I was after --

mysql_query("select from dbname1.table where x='000')
mysql_query("select from dbname2.table where x='000')