Dynamic graphs

[ncjbhd]

Hi there, Could someone tell me whether it's possible to create php dynamic graphs from a mysql database. What I would like to do is create flight charts for a selected moth species from a database where users have entered their records. What I need is some code that looks for the species ( common quaker for example ) in the 'species' field, then checks the month in the ' date' field and total up the number seen in the 'Numbers' field for that month. Then plot a simple bar chart with months on the x axis and numbers on the y.

It would be fantastic if that was possible and if it is, would someone be kind enough to help me with the coding for it? I hope so.

Thanks