Page 1 of 1

Displaying chart

Posted: Mon Jul 14, 2008 7:39 pm
by thatsme
Hi,

I want to generate an organization chart for a college.

The order of hierarchy are,

Principal Name
HOD (Head of the Departments) OR Divisions. Depends on the number of departments
Sections (Section Heads)
Lecturers/other staffs. //some staffs belong to whole departments like sweepers. They are shown separately. They are filtered out by using desig_id.


staff_table fields:- staff_id, org_id, fname, lname, desig_id

org_table fields:- org_id, div_id, sec_id

div_table fields:- div_id, div_name

sec_table fields:- sec_id, sec_name

desig_table fields:- desig_id, desig_name


Whenever a new divisions/sections are added they should be shown (sections should be shows under which divisions it belongs to).

I need a single array in which all required values (principal_name, division_names and their heads, section_names and their heads and lecturer_names) are available, so that i can loop it and generate html table or divs and display appropriate values.

For the last 4 days i am looking for a solution. Any kind of solution will be very helpful

Thanks