Third choice, definitely. And aren't you glad your data is sufficiently normalized that this is a no-brainer! Cheers - Miles Thompson At 12:51 PM 11/7/2002 -0600, Doug Coning wrote: >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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
