joejoebiggs

I need an estimate for the following work: I have a mysql table, responses, laid like: ans1 - number 1-10 wtaken - 2 digit week number that the record was entered dtaken - dd/mm/yyyy that the record was entered I need to find all responses that fall between 2 given dates, date_start and date_end which I am passing from a form. I then need to take the responses, break them down by week taken, and calculate the average which I then need to plot to a line or bar chart I would also like to have a fusionchart programmed to be run weekly to take the current week's results and plot a fusionchart pie chart that shows what percentage of the total results each number 1-10 is. Example: Results: 6 7 9 9 8 6 8 7 Would give me a pie chart where each number, 6,7,8,9 would represent 25% of the pie. Thank you in advance!

Hello, I am fairly new the FusionCharts and am trying to figure out how to plot a graph with the following information: Database: survey Table: responses Field: Ans1 Ans1 contains a number 1-10. I would like to show a graph of each number, 1-10, and the number of responses that contain that number. I have read the tutorial and when I alter the select statement to what I think should work I get a MySQL error. I was able to get it to plot each individual response in a pie chart, just not combined. (So at least I know it is functioning.) Thanks in advance for your help!