Geting data from two databases

[marcebra]

I have two databases that I need to simultaniously get data from. One of the databases has a ProductID -> ProductName conversion chart. The other database stores the information on the product based on the ProductID. I want to display all the information about each product based on the second database in a nice table. THe thing is that I want the first column of the line to be the ProductName and not ProductID. How do I make this loop go through two databases at once to write this?

[Kudose]

mysql_connect('localhost', 'username', 'password');
$db1 = mysql_select_db('db1');
$db2 = mysql_select_db('db2');

mysql_query("INSERT INTO table ('ProductID') VALUES ('$ProductID') WHERE dbname='$db1'") or die(mysql_error());
$ProductName = $ProductID;
mysql_query("INSERT INTO table ('ProductName') VALUES ('$ProductName') WHERE dbname='$db2'") or die(mysql_error());

[nemonoman]

Before things get too far afield, are you sure you have 2 databases and not 2 tables in a single database?

Do you have 2 separate usernames, 2 separate passwords, 2 separate logins, etc? That means 2 databases.

If you have 1 login, but you're storing data in 2 data areas, those data-thingies are called 'tables', and your problem is simpler.

[marcebra]

oh, in that case, i mean a table .. it's all under the same username and password (but i dont see how its' so easy)

[nemonoman]

Try searching these forums for messages about JOINs.

You're describing a very simple and typical use of a database.

If you want specific help, post the structure of the tables in question.