| Daevid Vincent 2006-02-25, 9:43 am |
| 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...hical-data.html
http://www.sitepoint.com/article/hi...l-data-database
http://www.zend.com/zend/tut/tutori...torial-ferrara2
&id=3453&open=1&anc=0&view=1
http://simon.incutio.com/archive/20...19/storingTrees
http://istherelifeafter.com/joecelko.html
http://www.codeproject.com/cs/datab...as
es.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/mysql? unsub...sie.nctu.edu.tw
|