I'm trying to do a pretty basic recursive function, but am not really sure how to get started. I understand the database structure concept, it's the code that's hanging me up.
So what I want to do: Quite simple, just output a "tree" like:
-- option 1a
--- option 1b
-- option 3a
-- option 3b
-- option 3c
...and so on.
My database structure is:
option name (the option name itself, "option 3a") from above
parentid (the parent id of the item itself - a zero for parent id means it's a main item, a non-zero value means it's under some main item)
How would you create the actual code to spit out the example structure above?