connecting to 2 db's on the same page

[pinehead18]

I need to pull information from 2 db's on the same page.. I'm putting the sql code right on top of each other and it is not working.. Anybody know a good way of doing this?

Thank you
Anthony

[Moonglobe]

are you doing:

$db1 = mysql_connect(/*blah*/);
$db2 = mysql_connect(/*blah*/);
mysql_select_db($database1,$db1);//note the second param
mysql_select_db($database2,$db2);
//etc.......

? or do you need [man]mysql_db_query[/man]?

(assuming your on MySQL, you'll obvoiusly know the functions for your db of choice 😉)

[pinehead18]

so for the select statment is it like sql = "SELECT * FROm db1 and db2 where uname = uname ???

[kellog]

Originally posted by pinehead18
so for the select statment is it like sql = "SELECT * FROm db1 and db2 where uname = uname ???

I doubt your going to be able to grab info from two databases with the same sql string. What your probably going to have to do is grab info from db1, then from db2, then merge the data together.

[Moonglobe]

Originally posted by pinehead18
so for the select statment is it like sql = "SELECT * FROm db1 and db2 where uname = uname ???

the FROM is for the table..... normally you select the database for the entire connection, but you want to look up [man]mysql_db_query[/man]

[osusano]

well i dont know the best way too but i have same problem b4 and what i did is i query the DB1 and assigned the value i get into a variable and query the DB2 and same thing assigned it to a variable and print it maybe this will help

[Moonglobe]

post some code; and besides, are you actually using two connects, or just to databases at localhost?