the modified pre-order tree transversal seems interesting, but if I want to modify one element I have to go through the whole table to re-index everything....and I would like to avoid to use recursive methods..
I'm currently using a table with orderId whichis an integer, but again I have to modify all the records in case of addition.
I have a script to do it,but was wondering if for ex it was possible to store directly a structure in mysql, or using a file (xml?)or something I could easily update.
I was wondering if somebody here already tried something like that or if it is a stupid idea....
Ian Gibbons wrote:
On 18 Oct 2004 at 15:27, Melanie wrote:
Hi,
Does anybody has a simple idea to store a tree structure under mySQL 4.1.5?
I have one table with id, familyType,superFamily,family, for example:
Hi,
This tutorial (PHP + MySQL) shows a few different methods:
http://www.sitepoint.com/article/hierarchical-data-database
I found this by typing:
storing tree structure in mysql database
into Google ;)
Ian --
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
