Pie chart based on MySQL query

[pelonms7]

Hi,

I would like to make a pie chart base on MySQL query, basically one of the tables has a field called "agent" and another one called "location", one agent can have several locations, I want to show a chart that shows how many locations has every agent.

Is this possible? I tried using pChart but it is difficult and I am new with this.

Thanks in advance

[pelonms7]

Does someone has an idea?

[Günter_Schenk]

pelonms7 wrote:

Does someone has an idea?

Creating charts from MySQL recordset results is a rarely realized requirement within the Dreamweaver user community, so it´s not to be expected that such a question will trigger instant responses.

You said that you "tried using pChart but it is difficult..." -- does this mean that what you want is not possible with pChart, or can it be done, but would require a better understanding of how pChart works ?

However there are (commercial) Dreamweaver extensions available such as Webassiist´s "Dynamic Web Charts" which may be what you´re looking after.