[thelist] Recursive Queries

Sarah Adams mrsanders at designshift.com
Thu Mar 9 16:35:11 CST 2006


> How would one display all available products and departments in a
> recursive navigation inside a recursive query?

I like this method, which would allow you to do this in a single query:
http://www.sitepoint.com/article/hierarchical-data-database

You could probably do it in a single query with your current structure,
but it would require a *lot* of looping.

-- 
sarah adams
web developer & programmer
portfolio: http://sarah.designshift.com
blog: http://hardedge.ca



More information about the thelist mailing list