How to create dynamic organization/pyramid chart, help pls!

[RaffiqEddy]

Hello Expert!

Can anyone guide me how to create dynamic organization / pyramid chart which look like this:

http://www.elagenda.com/pyramid.bmp

I found similar sample

http://www.tek-tips.com/viewthread.cfm?qid=316739

-- the sample format is from right to left, furthermore it has no line showing so the chart not complete..

TIA

Regards.

 

[TonyGroves]

This is hardly a MySQL matter, is it?

 

[RaffiqEddy]

I used php & mysql

The data are from mysql, I hope someone can help me how to do this chart with that combination

Am I in wrong forum?

 

[Foamcow]

The MySQL portion would be a table with columns for

id - a unique id number for each row
name - arbitrary name for the "thing"
parentId - the id of the parent "thing"


So then each row would contain information for each "thing" and you'd be able to work out your tree structure based on what was a parent of what.


As far as actually generating the graphical representation of that data - it's an entirely different matter and nothing to do with MySQL.

<honk>*:O)</honk>
Foamcow Heavy Industries - Web site design in Cheltenham and Gloucester
Ham and Jam - British & Commonwealth forces mod for Half Life 2