Posted by Jerry Stuckle on 07/24/07 10:52

Dave wrote:
> On 24 Jul, 10:02, Hendri Kurniawan <ask...@email.com> wrote:
>> 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
>
> I apologise if what i asked is way off topic for this newsgroup. I did
> do extensive searches through google and the newsgroups, and it
> appeared that many people did post questions in this group regarding
> mysql.
>
> Other than that, i couldnt find any newsgroups regarding MySql.
>
> Again I thank you for your reply, but this woudl be taking the
> database too far for what we require. It is only for our sales
> departments intranet, to help in training staff. They do not require
> the purchasing side to be added.
>
> I will continue to search the internet to find a more appropriate
> place to post my query.
>
> Thanks again Hendri
>
> Dave.
>

Did you try comp.databases.mysql?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]