|
|
Posted by Jerry Stuckle on 07/24/07 11:15
Dave wrote:
> 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.
>
Dave,
But this question had nothing to do with PHP, so you could have left PHP
out of your search and possibly gotten a better newsgroup.
And yes, a lot of people come here asking about MySQL, and they will as
long as people continue to answer those questions. I know people are
trying to be helpful - but they would be even more helpful if they
directed people to a more appropriate newsgroup.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|