Best Possible solution for creating sub categories for websites

numerical25

Im creating a admin page for my website, that allows the user to set up categories and sub categories for the web site. I would like to know what the best possible solution to do this would be. Should I have it where the user is able to create New Tables that represent sub categories that are in relation to the main category. Or should I have a table called subcategories that list a bunch of sub categories in it with the categories as the foriegn keys. My problem is , what if someone wants to make a sub category of a sub category. it seems really complicated.

I would like to know how the professionals do it

Piranha

This thread may give you some idea.

NogDog

You could just have one categories table, and in it have a column for "parent" category, which would contain the ID of the category for which this row is a sub-category. If the value of "parent" is set to null, or zero, or whatever other special value you want to use, then it would be considered a top-level category.

nbaalen

Perhaps this explination helps a little
http://www.niekvanbaalen.net/swiftbox/swiftbox/sbmain_e.html

numerical25 wrote:
Im creating a admin page for my website, that allows the user to set up categories and sub categories for the web site. I would like to know what the best possible solution to do this would be. Should I have it where the user is able to create New Tables that represent sub categories that are in relation to the main category. Or should I have a table called subcategories that list a bunch of sub categories in it with the categories as the foriegn keys. My problem is , what if someone wants to make a sub category of a sub category. it seems really complicated.

I would like to know how the professionals do it