We have built several programs that build a tree structure an infinite amount of levels deep.
the best way we have found to do it is to have a table that contains all items each with a unique reference. for example with 2 columns folderId and folderName; Then have another table called folderchildren with columns parentFolderID and childFolderID. both the columns in the folderchildren table are primary and foreign keys referencing the main folder table. then each time you add a new folder you add it in the main folder table then take its parent id and save it in folderchildren table. then when building the tree you start with the top node and run a recursive function that keeps checking for any children each time it adds a new folder. we have found this very effective but of course it is managed and built through the server code as opposed to being built from within mysql. if you need any more help just let me know. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292107 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
