Richard comes through again --- in spades!!
Miles
At 09:35 AM 3/26/01 +0100, [EMAIL PROTECTED] wrote:
>You may want to check out my tutorial on recursively processing this
>sort of structure on the easysoft website:
>
>http://www.easysoft.com/tech/php/tut_002/main.phtml
>
>Hope this helps
>
>
BDY.RTF
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Joe Celko wrote a book called "SQL for Smarties" that has about 20 pages
devoted to representation of trees in SQL. I believe he also has a website.
His quick take on representing trees in SQL is that hierarchical databases
do this far better and a RECURSIVE UNION funtion is needed to do this
