survey results to show as a graphic

[kevinritt]

Hello,

I have a form set up to take an online survey that asks 2 questions.

<form action="" method="post">
Are you satisfied with the current administrator's job?<br />
<input name="current" type="radio" value="yes" />Yes<br />
<input name="current" type="radio" value="no" />No<br />
<br />
Will you vote for your current party affiliation in the next election?<br />
<input name="affiliation" type="radio" value="yes" />Yes<br />
<input name="affiliation" type="radio" value="no" />No<br />
</form>

What I'm trying to do is show the current results of the survey as a bar graph and percentage instead of just a number. How would I determine how many people entered the surver to display % results? Is this possible?

[Mchl]

How do you store results?

[.josh]

simple math...

 

$percentyes = ($totalyes / $total) * 100; // percent of people who entered 'yes'

 

How you populate those vars depends on how you are storing the data, as Mchl pointed out.  As far as displaying it as a graph, you would have to dynamically build an image using gd library.  Or you could just google for one of the millions of prefab scripts that already do that..

[kevinritt]

How do you store results?

Sorry, I have a MySQL table set up to capture the selections of yes/ no on both questions

[Mchl]

Then just count the rows.

http://dev.mysql.com/doc/refman/5.1/en/counting-rows.html