php/mysql Graph Generation

[lukekelly]

Hi All,

 

I'm looking for a graph solution for data. Has anyone ever used any kind of graph generation scripts? Basically im looking for advice on the best method to go about this.

 

Thanks

 

Luke

[kickstart]

Hi

 

There are a few around but the best are paid for.

 

I landed up writing my own for basic lie graphs. Creating them with the graphics functions isn't too hard.

 

All the best

 

Keith

[Adam]

The best things in life are free!

 

http://phpmygraph.abisvmm.nl/

 

I've never used it, but looks pretty good.

[lukekelly]

Thanks for replies guys, that phpmygraph looks pretty simple and good to use; but im just thinking how the data would get into there, guessing it has to be manually entered.

 

Ive found this http://www.fusioncharts.com which supports a lot of languages and does have mysql connectivity. I guess what would really suit my needs is the ability to select a month, then output all related data to that month into a bar chart. The y axis would contain numbers 1 - whatever and the x axis would contain the client, but within the client there would be 4 datasets (just 4 different numbers) so it would look a bit like this http://upload.wikimedia.org/wikipedia/en/thumb/c/c9/Literacy_Bar_Chart.jpg/590px-Literacy_Bar_Chart.jpg

 

on that chart they have two datasets for each area in india, 1981 and 2001. So same principal just mine would have 4 for each.

 

Ideally to produce this graph i would litrally just want a drop down box to select a month that will produce the graph - but it must be able to pull the data direct from mysql without any human entering. Although i am open to other suggestions / ways of tackling this

 

Thanks