I need to retrieve data from a mySQL table and display it on a webpage. I have a survey on my website with the results going to a mySQL db. I would like to display the results of that survey.
My table has 7 fields and the value can be anyone of 5 different options that the user taking the survey can select.
I would like to display the results of each question as a percentage. I.E.
1. Food Quality- Excellent Very Good Good Fair Poor
75% 20% 3% 2% 0%
and so on and so on for each of the questions I asked.
Help please!
Thanks,
Robert