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
>
> _____
>
>~ Richard Allsebrook ~
>Applications Developer and Webmaster
>Easysoft Limited, Thorp Arch Grange, Thorp Arch, Wetherby, LS23 7BA, UK
>http://www.easysoft.com <http://www.easysoft.com> -
>http://www.cinema.com <http://www.cinema.com>
>"A computer lets you make more mistakes faster than any invention in
>human history - with the possible exceptions of handguns and tequila."
>
> _____
>
>
>
>
>
>-----Original Message-----
>From: antiphobo [mailto:[EMAIL PROTECTED]]
>Sent: Saturday, March 24, 2001 11:28 AM
>To: php-db
>Cc: antiphobo
>Subject: FW: [PHP-DB] Tree structures...
>
>
>What's the best way to deal with tree structures? Use the following
>setup in
>a database as an example:
>
>ID | Parent | Description
>------------------------
>1 | | Colours
>2 | 1 | Red
>3 | | Hello
>4 | 1 | Green
>5 | 4 | Light
>6 | 4 | Dark
>
>
>This should be represented as:
>
>1. Colours
>4. +--Green
>6. +--Dark
>5. +--Light
>2. +--Red
>3. Hello
>
>(ie, in tree structure and ordered alphabetically by 'descriptiu
>
>What's the best way to select the data and render it in HTML?
>
>I thought about going thru each element (of the whole table) at a time,
>and
>making an array, dynamically adding bits of the tree together until the
>whole tree has been grown ... but it seems a little bit complicated and
>slow
>... is there anything that could be done [database]server-side which
>might
>help me?
>
>Or do other people have code snippets, ideas or anything which might
>help
>me??
>
>Thanks,
>
>Siggy
>
>
>
>
>--
>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]
>
>
>
>--
>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]
--
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]
