Getting data from table as a tree
| From: | pt2002 | Date: | Thu, 05 Aug 2004 10:24:57 +0000 |
| Subject: | Getting data from table as a tree | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-192822@lists.php.net to get a copy of this message | ||
Hi
I have a table like this
id, pid, name. When a item has no parent, pid = 0. There is no limit in
depth.
1, 0, Test 1
2, 1, Test 1.1
3, 1, Test 1.2
4, 2, Test 1.1.1
5, 1, Test 1.3
6, 3, Test 1.2.1
I need to read this table and return an array that represents the tree.
Maybe using a recursive function but had no success.
I just need someone to point in the right direction.
TIA
Greets
pt2002