All pastes #424632 Raw Edit

Someone

public text v1 · immutable

·published 2007-04-04 22:34 UTC

table
+-------------+
| id          |
| description |
| parent      |
| order       |
+-------------+

Can that data be put in an array with a tree structure like this

+ id,description
|       +---------+ id,description  
|                 + id,description  
|                 + id,description  
+ id,description
|       +---------+ id,description  
|                 + id,description  
|                 |       +---------+ id,description  
|                 |                 + id,description  
|                 + id,description  
+ id,description
        +---------+ id,description  
                          +---------+ id,description  
                                    + id,description



+ 10,mark
|       +---------+ 11,kathleen
|                 + 3,jimmy  
|                 + 1,steven  
+ 5,john