Link to home
Start Free TrialLog in
Avatar of sink21
sink21

asked on

Recursive Function Help

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:

option1
-- option 1a
--- option 1b

option 2
option 3
-- option 3a
-- option 3b
-- option 3c

...and so on.

My database structure is:

id (autonum)
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?

Thanks!
Jake
ASKER CERTIFIED SOLUTION
Avatar of RCorfman
RCorfman

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RCorfman
RCorfman

Strike out the comment about returning the count. That got too complicated and wasn't part of the scope of the question.