Hi Jan,
Apologies in advance if any of this seems too pedantic.
What you are essentially looking for is SQL capable of handling tree
structures so you can pull this data in a single fetch. You can read
about this in Joe Celko's SQL for Smarties or (more specifically) Joe
Celko's Trees and Hierar
Hi,
my database is organized such that every page has a hierarchical superior page
("mother"). When displaying a page, a little drop-down menu should be displayed
with all the mother, grandmothers etc. until the loop hits a page of the root
type (and unless the page itself is a root page).
I c