selecting 2 databases

[fredouille]

Hi
all

Im' workling on several db with the same script...it seems that I have to select each db before using it is not possible to have 2 db selected...any solution ?

[drawmack]

$db1 = mysql_select_db(.....);
$db2 = mysql_select_db(.....);

$query = mysql_query("SELECT * FROM <table>",$db1);
$query2 = mysql_query("SELECT * FROM <table>",$db2);

[fredouille]

Originally posted by drawmack

$db1 = mysql_select_db(.....);
$db2 = mysql_select_db(.....);

$query = mysql_query("SELECT * FROM <table>",$db1);
$query2 = mysql_query("SELECT * FROM <table>",$db2);

[/B]

http://ro.php.net/manual/en/function.mysql-select-db.php

mysql_select_db return TRUE FALSE not a link variable like sql connect

in a mysql_query it is the link var which is called...link var coming form mysql_connect

[drawmack]

I stand corrected, however if you read the user comments on the page you linked to they'll tell you how to accomplish what you're looking for.

[fredouille]

Originally posted by drawmack
I stand corrected, however if you read the user comments on the page you linked to they'll tell you how to accomplish what you're looking for.

yes yes I found the answer....in fact several select db works