Jay Blanchard wrote:
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