We have a website set up using cake PHP, we would like to add a graph into this page, http://www.titaniumracetiming.co.uk/results/timings/pages/event_rider_detail/12/13735
The graph should be formatted as per the designs we will supply, the graph should use the data in the database to plot the graph.
The user must be able to select a drop down to change the data displayed, e.g change from Male, Female or Category Type.
The number of data points should be customised per race, I suggest making a new attribute in the race table, it will typically be 18 per race.
On the X axis, it should show the fastest and slowest times at the extremes then divide the times up into X integers specified in the 'race' table.
On the Y axis, it should use the race ID to count those with the same raceID and also the status "Finished". The first value should be 0, and the upper value should be the total number of finishers for that race rounded up by 5% so that the line does not plot up to the...