Page 1 of 1

I need help for a organisational chart

Posted: Tue Aug 12, 2003 12:29 pm
by Qweb
I am trying to code a script for drawing a organisational chart. I'm using MySQL and PHP ... but I just can't do the code which sort the database like:

DATABASE:
Table: organisation
Fields:
id, department_name, depends_on, commands_on, level
-----------------------------------------------------------------
1 General Manager 0 2 1
2 Technical Man 1 1 2
3 Comercial Man 1 2 2
4 Engineer 2 1 3
5 Marketing 3 2 3
6 ......

and so on ...

Now, this data must be represented as any organisational chart.

Can anyone help me with this ?
PS: If you know any script who can do the job, please let me know.
Thanks.