Re: Structure Question...
| From: | Ignatius Reilly | Date: | Thu, 07 Nov 2002 17:59:41 +0000 |
| Subject: | Re: Structure Question... | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-23103@lists.php.net to get a copy of this message | ||
You have to create a table:
CREATE TABLE product_categ (
FK_productID <definition>,
FK_categID <definition>
)
and list all relationships "productID belongs to categID"
Ignatius
____________________________________________
----- Original Message -----
From: "Doug Coning" <lists@coning.com>
To: <php-db@lists.php.net>
Sent: Thursday, November 07, 2002 7:51 PM
Subject: [PHP-DB] Structure Question...
> Hi everyone,
>
> I'd like to know how you would set up the following:
>
> I've set up a MySQL database with 600 products. I set it up where each
> product belongs to a category. However, now we want to take it further
> where different products can now belong to more than 1 category.
>
> How would you create this?
>
> 1. Would you duplicate the records for items that belong to more than 1
> category and change the categories in those duplicated records?
>
> 2. Would you enter multiple categories into 1 column?
>
> 3. Would you create a different database that tracks categories and creat
a
> many to many relationship?
>
> Thanks,
>
> Doug Coning
>
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>