Jay Blanchard wrote:
[snip] ...stuff... [/snip] I rewrote everything so that I could get the data in a single query and then performed some manipulation with PHP to get the proper output. No need to call multiple queries in this case, just had to sleep on it.
In Firebird, CTE queries are great for this type of problem. Just having a single result set and formatting the results based on a 'level' field makes things very flexible and you just stream the one set of results.
-- Lester Caine - G8HFL ----------------------------- Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
