Hi, As your using MySQL5, I'd recommend putting all the Nested Set code in stored procedures, that way the client doesn't need to know about anything about the method, and the left, right columns never need to be retrieved. Jared > 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=tut > orial-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 > > -- > PHP General Mailing List (http://www.php.net/) To > unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
