Projecting tree structure to MySQL database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
visionmaster
Forum Contributor
Posts: 139
Joined: Wed Jul 14, 2004 4:06 am

Projecting tree structure to MySQL database

Post 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!
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post 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
Post Reply