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
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