Recursive Drop down from db

[Nate]

I'd like to change the following (table):

CategoryID  ParentID  Name  

1           NULL      Folder 
2           1         Sub Folder 
3           1         Sub Folder 
4           NULL      Folder
5           4         Sub Folder
6           5         Sub Folder 
7           5         Sub Folder
8           5         Sub Folder

to a drop down box that would look like:

[SELECT ONE]
Folder
- - Sub Folder
- - Sub Folder
Folder
- - Sub Folder
- - - - Sub Folder
- - - - Sub Folder
- - - - Sub Folder

I understand I need to use a recursive function but i don't quite understand how to start writing it...

Does anyone have example code of how they accomplished something like this?

Thx,
Nate

[Natty_Dreadlock]

hi,
i got some code that's working for me, i can send it to you if u want...

[Nate]

Yes, please do! [e-mail]

thanks!