css menu unlimited submenus db driven

[eluser]Pascal Kriete[/eluser]
If you need unlimited depth AND need to extract a full path, the best solution is a tree based structure.
The MySQL site has a pretty good article on how you would implement something like this, which can be found here.

On the other hand, if you only ever need the current level as well as the parent and the children, you could create an intermediate table for relationships. ExpressionEngine, for example, takes this approach.