...

View Full Version : Multiple Categories and MySQL



Camron467
05-03-2009, 09:08 PM
I am about to write a script, and was wondering how you would go about organizing a database so it each item could have more than one category, I know there are ways of doing this, I am just not sure how.

Anybody know?

-Camron

venegal
05-03-2009, 09:20 PM
Supposing you have your items in one table and your categories in another one, you will need a third table, the join table. Each row there will consist of an item id and a category id, and will represent one item-category connection.

Camron467
05-04-2009, 12:07 AM
Okay, so I think I understand what you are saying. Thanks.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum