RE: [PHP] Two websites need to share part ofonedatabase,suggestions please

On Tue, 2005-07-12 at 14:50, Chris W. Parker wrote: > Robert Cummings <mailto:robert@interjinn.com> > on Tuesday, July 12, 2005 11:47 AM said: > > > Sorry to respond so late, my free time these days is sporadic :) > > No problem. > > > My example suggested one database to host all products for both sites. > > The bitmask is used as a filter to determine which sites can access > > the product information. In this way you keep your products > > centralized while providing easy access for either site 1 or site 2 > > customers. > > Oh I see. And I guess the same technique would be applied to the other > tables like 'customers', 'coupons', 'orders', etc. Absolutely. > > > I also mentioned when I first suggested it, and as another response > > mentioned, that you could go with a separate table that provides site > > to product relationships and that would be scalable to many more > > sites. > > I think I'm going to do something like this. Cool :) Cheers, Rob. -- .------------------------------------------------------------. | InterJinn Application Framework - http://www.interjinn.com | :------------------------------------------------------------: | An application and templating framework for PHP. Boasting | | a powerful, scalable system for accessing system services | | such as forms, properties, sessions, and caches. InterJinn | | also provides an extremely flexible architecture for | | creating re-usable components quickly and easily. | `------------------------------------------------------------'