Re: [PHP] {SOLVED] mysqli & nested queries - maybe I'm rusty...
[email protected] (Lester Caine)
| Newsgroups | php.general |
|---|---|
| Message-ID | <[email protected]> |
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