Page 1 of 1

Projecting tree structure to MySQL database

Posted: Sat Dec 18, 2004 4:05 pm
by visionmaster
Hello together,

What is the best solution of projecting a tree structure of attributes to a mysql database?

products (for) reference (purpose) attribute
--------------- ---------------------- ---------
signboards presentation messing
press roads laminated wood hydraulically


Thanks for your help!

Posted: Sat Dec 18, 2004 9:02 pm
by timvw
there is more than enough stuff to find for implementing a tree in sql...

fe: http://www.dbazine.com/tropashko4.shtml

if you decide to use the nested set approach, you might be interested in the pear package http://pear.php.net/package/DB_NestedSet