Database design: categories solution

[NickVK]

Hi guys.

What is the best solution of categories in e-shop?

I'm thinking about:

---

| id | name | parent |
|---+------+-----------|
| 1 | Super Category | 0 |

| 5 | Sub Category | 1 |

Is there any better solution?

Thank's

[dagon]

your basically right, here is a good article on it: Managing Hierarchical Data in MySQL