Infinite categories and sub-categories

[vividona]

Hi,

Please help

I need to make categories with su-categories
I made in my database tables like this

table = categories

cid | cat_id | parent_list | categ_name | type
1 0 1 General category c
2 1 1,2 sub category s
3 1 1,3 sub category s
4 1 1,2 sub category s
5 1 1,5 sub category s
6 5 1,5,6 sub sub category s
7 0 7 General category2 c
8 7 7,8 sub category s

I need to view this in dropdown menu using parent_list column

[NogDog]

Here's a fairly comprehensive look at two common approaches, with the "nested set" model probably being better when you do not have a fixed depth to the data hierarchy: http://mikehillyer.com/articles/managing-hierarchical-data-in-mysql/