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.
I need help for a organisational chart
Moderator: General Moderators