[SOLVED] Using two different databases to reduce results in PHP

[upperbid]

Say I first generate a list of results of purchases from a specific user from a database showing the product number with all the other data, which I can already do successfully.  For example, results currently are like:

 

Product number, Description, Quantity, Price

7897797, chair, 1, $49.99

8797879, stool, 2, $24.99

6897679, table, 1, $149.99

 

I then need to further limit those results based on criteria from another database which only gives information on the product, such as the manufacturer but does not contain any of the purchase information. Say I wanted to only return the results of the purchases from that buyer that were from a manufacturer called Tom's Wood which would be stored in another database.

 

I can use the product number from the first results since the product number is the common factor in both databases, but I'm not quite sure how to do this second part.  I would like the result to return both parts for the specified criteria (in this case all purchases from the buyer with the specified manufacturer Tom's Wood) together like:

 

Product number, Manufacturer, Description, Quantity, Price

7897797, Tom's Wood, chair, 1, $49.99

8797879, Tom's Wood, stool, 2, $24.99

 

Any suggestions would be appreciated.

[upperbid]

I actually meant two different tables in the same database.  I wanted to modify the original post, but I don't see an option to do so.

[Garethp]

http://articles.techrepublic.com.com/5100-10878_11-1050307.html

[upperbid]

I resolved this by using strictly MYSQL to pull the results with a SELECT statement for multiple tables with various WHERE requirements.