RE: [PHP] Two websites need to share part of one database, suggestions please

2005-07-11 Thread Nathan Tobik
This seems to be the best option of the one you presented. If you start duplicating data you will have a situation where your data will get out of sync eventually. You can have a lookup table with the keys to the items that belong to website two, just look in the lookup table to get your key,

Re: [PHP] Two websites need to share part of one database, suggestions please

2005-07-11 Thread Brad Pauly
On 7/8/05, Chris W. Parker [EMAIL PROTECTED] wrote: Which option should I go for? Is there another option I'm not considering? Another possibility would be adding a new table that relates products to sites. This allows a one (product) to many (sites) relationship without changing the products

Re: [PHP] Two websites need to share part of one database, suggestions please

2005-07-11 Thread André Medeiros
What about using web-services (something ala xml?). Could that be considered an option? On 7/11/05, Brad Pauly [EMAIL PROTECTED] wrote: On 7/8/05, Chris W. Parker [EMAIL PROTECTED] wrote: Which option should I go for? Is there another option I'm not considering? Another possibility

RE: [PHP] Two websites need to share part of one database, suggestions please

2005-07-11 Thread Chris W. Parker
André Medeiros mailto:[EMAIL PROTECTED] on Monday, July 11, 2005 12:44 PM said: What about using web-services (something ala xml?). Could that be considered an option? No because I don't how to use that stuff. :) Chris. -- PHP General Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP] Two websites need to share part of one database, suggestions please

2005-07-11 Thread André Medeiros
XML is quite easy. Let's say you're making a search for books, and you have site1.com searching site2.com for some stuff. site2.com could have some sort of back end like http://site2.com/_backend/search.php?keywords=a+book That would search it's database for the keywords a book. It could

RE: [PHP] Two websites need to share part of one database, suggestions please

2005-07-11 Thread Chris W. Parker
André Medeiros mailto:[EMAIL PROTECTED] on Monday, July 11, 2005 3:08 PM said: XML is quite easy. Let's say you're making a search for books, and you have site1.com searching site2.com for some stuff. site2.com could have some sort of back end like I see what you're saying. But that

Re: [PHP] Two websites need to share part of one database, suggestions please

2005-07-08 Thread Robert Cummings
On Fri, 2005-07-08 at 18:20, Chris W. Parker wrote: Hello, We have two websites. One website is already up and running, the other is not. The first website (I'll call it one.com) contains a large number of the products and is meant for a specific audience. The second website (I'll call

RE: [PHP] Two websites need to share part of one database,suggestions please

2005-07-08 Thread Chris W. Parker
Robert Cummings mailto:[EMAIL PROTECTED] on Friday, July 08, 2005 3:32 PM said: Use a bitvector field in the table and use a bitmask for filtering for which sites can access what products. I think I understand what a bitmask is after doing some research but would you please give me an

RE: [PHP] Two websites need to share part of one database,suggestions please

2005-07-08 Thread Robert Cummings
On Fri, 2005-07-08 at 19:46, Chris W. Parker wrote: Robert Cummings mailto:[EMAIL PROTECTED] on Friday, July 08, 2005 3:32 PM said: Use a bitvector field in the table and use a bitmask for filtering for which sites can access what products. I think I understand what a bitmask is