I've been searching the web for the past few hours trying to find a simple drop-in class or functions to implement "Nested Set Model" or "modified preorder tree traversal".
I've found several tutorials and related links: http://dev.mysql.com/tech-resources/articles/hierarchical-data.html http://www.sitepoint.com/article/hierarchical-data-database http://www.zend.com/zend/tut/tutorial-ferrara2.php?article=tutorial-ferrara2 &id=3453&open=1&anc=0&view=1 http://simon.incutio.com/archive/2003/06/19/storingTrees http://istherelifeafter.com/joecelko.html http://www.codeproject.com/cs/database/Trees_in_SQL_databases.asp I even found some outdated PEAR DB_NestedSet class from 2003 that seemed way to overly complicated. And some other PHP4_Mysql3MPTTA class on PHP Classes that was equally complicated and written for ancient PHP4 and mySQL 3!! Hasn't anyone else done this before (recently)? Did everyone just write their own code every time? Anyone have some easy to use code that allows for: Add, delete, update/rename, select, show tree, bread crumb display, etc. I use PHP 5.0.5 and mySQL 5.0.18, so ideally it would take advantage of all the optimizations and bells & whistles of those more modern versions. TIA. D.Vin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
