Displaying chart

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
thatsme
Forum Commoner
Posts: 87
Joined: Sat Apr 07, 2007 2:18 am

Displaying chart

Post 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
Post Reply