Hello,

I am running 2 different businesess, each has their own e-commerce website (php+mysql), and each has their own set of products.

Site A has about 5000 products (should be doubled in the next few years), site B has only a few hundred products.

Now there are some categories on site B that should also be displayed on site A. And here i run into troubles. The problem is not so much to show these categories in the categorie-list, but more for an overview page, like "new products", that should display all products, based on the date they were added. Thus, this list should be a mix of products from 2 databases. Of course, i can only query 1 database at a time, and then display all from the 1st database, and then from the second database, but then you loose the point of "new products", as they will no longer be sorted by date.

How would you get around this?

Thanks!

Matt

Merge the two arrays, sort the resulting array on date.

MySQL allows you to select data from multiple databases in one select query as long as both databases are on the same server:

select * from db1.table1,db2.table2
where table1.id=table2.id

More info:
http://www.sialnity.com/2010/08/mysq...ltiple-tables/