Posted by denisb on 10/19/07 22:04

uidzer0 <ben.lemasurier@gmail.com> wrote:
> I'm having a little trouble writing an algorithm to create a
> hierarchal structure from a database which looks like this:
> parent_id | child_id |
> ----------------+-------------+
> 1 | 2 |
> 2 | 3 |
> 3 | 4 |
> 3 | 5 |
> 5 | 6 |
> 5 | 7 |
> I would like to put this into an array which represents the following
> structure:
> 1
> \
> 2
> \
> 3
> / \
> 4 5
> / \
> 6 7

if you understand french language :

<http://sql.developpez.com/arborescence/>

--
@@@@@
E -00 comme on est very beaux dis !
' `) /
|\_ =="

[Back to original message]