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.
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.
Powered by vBulletin® Version 4.2.2 Copyright © 2017 vBulletin Solutions, Inc. All rights reserved.