PHP retrieve data from unlimited level

[lilywong]

I have a function to create unlimited sub sub folders, and now i want to retrive the sub sub folders according to their level in a drop down box.

something to be display in a drop down box like below for user to select

[code]- A
- - A1
- - - A1.1
- - - - A1.1.1
- B
- - A1
- - - A1.1
- - - - A1.1.1
- C
- - C2 [/code]

one - will be added for top level folder, where parent ID =0, - - will be added for second level, - - - will be added for third level and so on. any ideas ?
coz now i mixed up all the level in one line as below which is very messy, and the current situation cannot differentiate the sub folder is belong to which main folder. thanks

[code]A
A1
A1.1
A1.1.1
B
A1
A1.1
A1.1.1
C
C2 [/code]

[zq29]

How is the category information stored in your database? (How is it structured?)