I want to make line graphs from some economic modelling data stored in a mysql table. How can I do this?
January 21, 2012 – 4:54 pmI get the data from a csv (updated daily), place it in a mysql table, manipulate the data with php and then place the adjusted data into a new table. This is all done by cron jobs. Now I want to graph this data (line graphs of the index I create vs. time). How do I do this?
P.S. My site is hosted with GoDaddy.
Related posts:
- how to copy mysql table updates to another server efficiently?
- How do I make my MySQL table automatically make a timestamp when new data is added?
- Is there a boolean/logical data type in MySQL table ?
- How do I view the data in a mysql database table?
- How do I view the data in a mysql database table?
- Is it efficient to archive legacy data from MySQL to another TABLE or should it be another database file?
- How to pull data from mysql table to an perl array ro hash for later display of the data in the perl?
- How can I query a mySQL database for a table name using known data that resides in that table?
- How could you get a MySQL table to export saved data to an Excel document?
- how to take a php array and take the data to create mysql table names?
2 Responses to “I want to make line graphs from some economic modelling data stored in a mysql table. How can I do this?”
An example of a similar script is available for free download at http://web2coders.com – php modules tab.
Try it!
By just "JR" on Jan 21, 2012
you can use GD library for PHP. Check on PHP manual in topic Function Reference : Image Processing and Generation
By chlutak on Jan 21, 2012