View Full Version : Multiple Categories and MySQL

05-03-2009, 10: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?


05-03-2009, 10: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.

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