Math -- getting a percent of average

LordRogaine

I have a poll on my site where the users may vote for something. I would like to be able to get a poll result to show as a percent. For example--- If ten people vote and five of them vote "YES" I would like to be able to show a result of 50% of the members voted "YES"

I am using php with mysql. My table has a column where it is set up as enum('yes', 'no'). How would I set up a query that I can get the total number of votes and the percent that voted "yes" or "no".

Thanks in advance,

Lord Rogaine

sidney

query the total number of votes

then total the number of yes votes

the maths is (100/total votes) *yes votes

which will give you the pecentage of yes votes

to get no votes take yes percentage away from 100

$sql1=mysql_query("SELECT vote FROM table");
$sql2=mysql_query("SELECT vote AS COUNT FROM table WHERE vote = 'yes'");
$yesvote=mysql_num_rows($sql2);
$totalvotes=mysql_num_rows($sql1);
$yesper=(100/$totalvotes)*$yesvote;

LordRogaine

Thank you so much for the help! It works perfectly! I have just one more question. I'm getting some results that look like this--"66.666666666667". Is it possible to round off the number to a percent like "67" instead of "66.666666666667"? Thank you again for the quick reply and help.

Lord Rogaine

TheAndrew

Just do:

$yesper=round($yesper,0)

before youecho "$yesper";

LordRogaine

Thank you very much!!