|
|
Posted by Hendri Kurniawan on 07/24/07 09:02
Dave wrote:
> On 24 Jul, 08:42, Hendri Kurniawan <ask...@email.com> wrote:
-- SNIP --
> Thanks for the quick response.
> What you suggest is a good idea, but I am lost with how this would
> work when say over 1000 customers would buy multiple products. The
> product_company_table would need to have duplicate _id's. Although I
> know this is allowed, I am unsure how this would react when queried.
>
> Dave.
>
Hi Dave,
You do realize this is a PHP group.
You need to create tables that contains all of the purchases.
The following is an example of how you can accomplish this
purchase_table(
purchase_id
purchase_date
customer_name
....
)
purchase_product_table(
purchase_id
product_id
company_id ???
)
Hendri Kurniawan
Navigation:
[Reply to this message]
|