Generate dynamic graph from MySQL data

Question

How can I generate a graph based on data inside my database? For example, I want to display the traffic of a website between a 90 day span, and a graph will display this, like a line graph. I don't like the PHP image and GD functions, they are really pixelated and are actually PHP pages acting like images. I'm not sure if this is how I've seen it done on other websites, but I would like a smooth image.

Answer 1

Great question one awesome solution that i have done is to use: http://code.google.com/apis/chart/ The Google Chart has lots of great graphs etc.. you can use. What i did was look at the examples see how the data was formatted, then I wrote my query to match it.