You should create 3 tables, one for products, one for categories and one to relate the two. You should only store ID numbers that relate to products and categories.
On Thursday, November 7, 2002, at 01:51 PM, Doug Coning wrote:
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?
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php