1 e-commerce site must show products from 2 databases
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 there 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
View full post on Tycoon Talk
Databases, Ecommerce, from, MUST, products, show, site