Help doin maths

[richarro1234]

Hey,

i have a bit of code that cycles the DB getting the amount of votes for a survey.

 

<?$query2 = mysql_query("SELECT * from responses WHERE qid = $qid") OR die(mysql_error());//corrected
while ($ans = mysql_fetch_array($query2)) {?><?php echo $ans['response']; ?> (votes:<?php echo $ans['votes']; ?>)<br><?}?>

 

as you can see it uses <?php echo $ans['votes']; ?> to get the amount of votes for the selected ID,

now how do i add up the out-putted votes to get the total amount of votes for that question?

 

And also, how do i turn that output into a %'age for each vote?

I.E:

yes (25 votes) (X%)

no (15 votes) (X%)

Total votes: 40

 

Thanks

Rich

[premiso]

SELECT sum(votes) as votes, response from responses WHERE qid = $qid GROUP BY qid

 

Unsure if my SQL is correct, but that should get you what you want.

[Ken2k7]

I think you should use COUNT(*). I don't know what data vote holds. Count should tell you how many rows there are, which should mean how many votes. Then use PHP to do the math.