By mike.hobo on

Hey, I have set up a little website where users post their own music. And now I'm interested in providing some information for the artists who post music on the site. I would like to know if there is a way where I can provide charts and graphs for the audio nodes that they create. Like a line graph of daily plays or hits and be able to see the graph over different months or all-time.

I'm thinking I should just use a counter or something on each node, then use some graphing tool like swf graphs or something and take from the SQL. I'm not good on coding, but if anyone would like to help, maybe a new module could be created.

Comments

mike.hobo’s picture

mike.hobo commented

Well I'm guessing my solution would lie with SWFCharts: http://drupal.org/project/swfcharts

And a php code that takes the SQL data for the plays and puts it into another SQL database and everyday it will do that. Then take the database a put it into the SWF chart.

Does anyone know any code that would automatically take SQL data and insert it into another chart that has the date as the table or something?