Nested categories, subcategories and sub-subcategories

[vividona]

Hi friends,

 

suppose I have this table values

 

id    |  name    |      parent

1          x                  0

2          x                  1

3          x                  2

 

if parent == 0 it means the x (1) is main category

if parent == 1 it means x (2) is parent to the main x

if parent == 2 it means x (3) is parent to the parent x

 

and so on

 

how can I insert and fetch this idea in php code

[Ken2k7]

That structure doesn't make sense to me. Which is x(1)? Is it the first x? If so, I don't get it. And why go by name rather than id?