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 you've got.
http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci537290,00.html?Fr omTaxonomy=%2Fpr%2F282457 Kevin Fries > -----Original Message----- > From: David yahoo [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 25, 2002 3:39 PM > To: [EMAIL PROTECTED] > Subject: hierarchical struture into mysql > > > Hi all, > > I m looking for a tree struture for which can be easilly > queried with mysql > features. > I only know the tree with row having a parent id. > Retieving children can only be done with recursive : mysql > doesnt do that ? > > Thanks > > > _________________________________________________________ > Do You Yahoo!? > Get your free @yahoo.com address at http://mail.yahoo.com > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
