I want to retrieve the path to a single node in a hierachical database where only the parent node ID is stored as a reference. Could someone give me a query or some advice on how to write a query (ideally the first option - I m a MySQL noob) so that all the node titles in the end node s path are given in a generated table?
id name depth 10 Top level 0 22 Second level 1 34 3rd level 2 43 End node 3
I want to use this data to create on of those "you are here" lists like:
Home > Forums > Stuffs > ... > Topics
Thanks for any help,
James