|
|
Posted by Dave on 07/24/07 10:02
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.
Navigation:
[Reply to this message]
|