|
|
Posted by Dave on 07/24/07 11:03
On 24 Jul, 11:52, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> 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.
> jstuck...@attglobal.net
> ==================- Hide quoted text -
>
> - Show quoted text -
When I searched google for the problem i had ie: 'php+mysql+query
+multiple+tables' the only groups that came back were php groups. Like
I stated above, I apologise that this was in the wrong group, but I
saw many posts which asked about mysql, and that was the only reason i
posted here.
And I have now taken this to the right group.
Thanks for all the help
Dave.
Navigation:
[Reply to this message]
|