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. 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. 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. Link to comment https://forums.phpfreaks.com/topic/81080-db-design-question/#findComment-411946 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.