Posted by Sandy Pittendrigh on 04/17/06 03:06

I didn't study your table definition carefully, so maybe I'm assuming
too much from the subject heading and first paragraph
of your post.

But if you are trying to model hierarchical data,
that's not so easy to do with relations
(see Data on the Web by Bunneman)...not efficiently
anyway.

For truly hierarchical data, think about deep-sixing mysql
and using XML data, SleeplyCat and Xpath.
(SleepyCat or Exist or even Xindice).

Oracle and Mircosoft Sql server can also handle Xpath
now.

• Next in forum: xml won't parse....
• Prev in forum: looping in php
• Thread view: Re: Hierarchy using MySQL and PHP

[Reply to this message]