MySQL table structure question

Question

I've been looking around on SO and have been seeing a lot of questions about category tree menus and was wondering how would my MySQL table or tables look like so I can add many categories and count less sub categories and display them on my web site.

Note I will be using PHP & MySQL.

Paŭlo Ebermann · Accepted Answer · 2011-10-30 14:35:59Z

3

I usually use a structure similar to the one below:

Category
--------
CategoryId
CategoryName
ParentCategoryId

MySQL has a decent article on this subject, Managing Hierarchical Data in MySQL, if you are interested in doing some more research on the subject. It goes into this structure and gives you some sample queries on how to get the data you want for specific scenarios.

edited Oct 30, 2011 at 14:35

Paŭlo Ebermann

75k20 gold badges150 silver badges217 bronze badges

answered Aug 15, 2010 at 3:49

Abe Miessler

85.6k104 gold badges323 silver badges496 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Guido Hendriks Over a year ago

Exactly my thought, except for the annoying CamelCase.

OMG Ponies Over a year ago

+1: I've been known to use both--at the same time! :) Cool link, but MySQL's lack of hierarchical/recursive query support makes me instinctively recommend Oracle/SQL Server/PostgreSQL

lost-in-SO Over a year ago

@Abe Miessler Is this the best way to display url values like index.php?cat=category&sub=sub-cat

Abe Miessler Over a year ago

It's the best way to store this information. How you display it is up to you and PHP.

Abe Miessler Over a year ago

@lost-in-SO, I'm not a big PHP guy so probably better to create a new question for that.

|

Collectives™ on Stack Overflow

MySQL table structure question

1 Answer 1

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related