Simple Voting

ldtiw

Hey there,

i have a table with

id | answer | user | vote

I have the sql as for $getTotalVotes:

SELECT SUM(poll_votes.vote) AS total_answers
FROM poll_votes
WHERE poll_votes.user = '$user'

I have $getAnswers:

SELECT poll_votes.answer, SUM(poll_votes.vote) AS sum_vote, poll_votes.id
FROM poll_votes
WHERE poll_votes.user='$user' AND poll_votes.answer = '$answer'
GROUP BY poll_votes.user AND poll_votes.answer = '$answer'

It is working when i post a vote, and then is displaying either

Yes 1 (50%) or No 1 (50)

I cant get both results to be displayed. I have tried using $GetPossAnswers:

SELECT answer
FROM poll_votes
WHERE user = '$user'
GROUP BY '$user'

And then:

<?php do { ?>
      <?php echo $row_GetAnswers['answer']; ?> <?php echo $row_GetAnswers['sum_vote']; ?> 
      ( <?php $pct = 100 * (round ($row_GetAnswers['sum_vote'] / $row_getTotalVotes['total_answers'], 2 )). "%"; echo $pct; ?>
      ) <br>
      <?php } while ($row_GetPossAnswers = mysql_fetch_assoc($GetPossAnswers)); ?>

But it still only displays one or the other depending on which answer was selected.

Any ideas??

Thanks,

Danny

stevesweetland

im assuming the following things....

a) that the 'vote' field is used to identify what the user is voting for.
b) that we arent trying to show what user has voted for what, but to show a total vote statistic
c) that your 'answer' field will only ever have two answers in it, yes, or no.

if any of these isnt the case, give us a slap, then tell me what you're intending...

otherwise...

you need to query three times.

$sql = "SELECT * FROM votes WHERE vote = '#'";

and get total rows (we'll call this '$total'). you'll use this for your percentages.

$sql = "SELECT * FROM votes WHERE vote = '#' AND answer = 'yes'"

and get total rows (we'll call this '$yes'). you now have how many 'yes' answers there are

$sql = "SELECT * FROM votes WHERE vote = '#' AND answer = 'no'"

and get total rows (we'll call this '$no'). you now have how many 'no' answers there are

right, now.

easy peasy.

print "Yes $yes vote(s) (".(($yes/ $total)*100)."%).  No = $no vote(s) (".(($no / $total)*100)."%)

ldtiw

Hey there,

Kinda. Im needing to get the votes for a particular user from the url variable. Heres how its working:

http://www.dandgwebdesign.com/mwb/members/vote/vote2.php?user=dannylewin

It all works, but i cant get it to display BOTH yes and no!

Danny