Create web report and graph(s) from mysql data
Closed - This job posting has been filled.
The task is to create a web report and graph data from a mysql database.
The data is in the following table: http://i.imgur.com/Q6Phb.png
The column 'Faces' will contain numbers ranging from 1-10 and this data should be plotted with number of faces on Y-axis and time on X-axis.
Plots should be by hour and by day.
A good solution seems to be to use google graphing tools together with php, but if you have other proposals I will listen.
Full access to the Ubuntu server will be provided.