querying 2 databases using MYSQL and PHP 1

[phpnewbie]

I am writing a PHP script in which I need to query 1 table in one database, and one table in another MySQL db. I dont know how I should write the connect statement.

 

[Khaldryck]

you just have to create to connection, one for each database.

ex:
$conn=mysql_connect("database1","user","pass"
$conn2=mysql_connect("database2","user2","pass2"

then, as you need to query one databse or the other, you just use the correct connection

$res=mysql_exec($conn,"select * from table;"
if selecting in 1st DB
or
$res=mysql_exec($conn2,"select * from table;"
if selecting in 2nd DB Khaldryck
Programmer at the University of Brussel (Belgium)