Try looking up the Nested Set Hierarchy structure, which is mainly discussed
by Joe Celko.
There are a number of discussions on usenet (groups.google.com) about it, by
him. Also, here's a URL which gives his description. It's a good
structure, and with modification, looks like it can fit about any hierarchy
> -----Original Message-----
> From: David yahoo [mailto:david_devidal@stripped]
> Sent: Monday, March 25, 2002 3:39 PM
> To: mysql@stripped
> Subject: hierarchical struture into mysql
> Hi all,
> I m looking for a tree struture for which can be easilly
> queried with mysql
> I only know the tree with row having a parent id.
> Retieving children can only be done with recursive : mysql
> doesnt do that ?
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com