1 e-commerce site must show products from 2 databases

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 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

, , , , , ,

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Get Adobe Flash playerPlugin by wpburn.com wordpress themes


RSS Site FeedRSS Site Feed

© 1992-2011 DC2NET™, Inc. All Rights Reserved