webweever Posted December 10, 2007 Share Posted December 10, 2007 I currently have a DB with 1 table that I'm storing links in. It has 5 fields (id, name, url, description and tag). I want to add the ability to create and edit categories and put the links into whatever category. My question is do I create a table for each different category and how do I associate each link with a particular category? Any help or insite will be greatly appreciated. Quote Link to comment https://forums.phpfreaks.com/topic/81080-db-design-question/ Share on other sites More sharing options...
roopurt18 Posted December 10, 2007 Share Posted December 10, 2007 My question is do I create a table for each different category No. how do I associate each link with a particular category Via normalization. 1) Normalization: http://en.wikipedia.org/wiki/Database_normalization http://databases.about.com/od/specificproducts/a/normalization.htm 2) Will these categories be nested? http://dev.mysql.com/tech-resources/articles/hierarchical-data.html That may get you started. Quote Link to comment https://forums.phpfreaks.com/topic/81080-db-design-question/#findComment-411422 Share on other sites More sharing options...
fenway Posted December 11, 2007 Share Posted December 11, 2007 how do I associate each link with a particular category Via normalization. See the relevant sticky. Quote Link to comment https://forums.phpfreaks.com/topic/81080-db-design-question/#findComment-411946 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.