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]

Reply via email to