i want to count specific IDs from my tables

Question

i have this code

<?php 
    $votes_query=mysql_query("select * from votes where CandidateID='$id'");
    $vote_count=mysql_num_rows($votes_query);
    echo $vote_count;
?>

which fetches individual *ID*s from my votes table.

I need a code which can help fetch the sum of specific *ID*s.

Lets say, I have ID-205 and ID-209 in my table.

you should stop using `mysql_` function. for more info see here http://stackoverflow.com/questions/60174/how-can-i-prevent-sql-injection-in-php — krishna, Mar 13 '14 at 09:58
`select CandidateID, count(*) from votes where CandidateID IN (?,?..) group by CandidateID ` — xdazz, Mar 13 '14 at 09:59

score 0 · Answer 1 · answered Mar 13 '14 at 09:57

0

<?php
$ids = array('205','209');

$votes_query=mysql_query("select * from votes where CandidateID IN($ids) ");
$vote_count=mysql_num_rows($votes_query);
echo $vote_count;
?>

Put all ID's in an array & Use IN Clause of mysql.

answered Mar 13 '14 at 09:57

Ankit Pise

1,243
11
30

score 0 · Answer 2 · answered Mar 13 '14 at 11:23

0

<?php 
    $ids = array('205','209');

    $sql  "SELECT SUM(field_score) AS vote_score FROM votes WHERE CandidateID IN ($ids)";

    $vote_score = mysql_query($sql);
    echo $vote_score;    
?>

answered Mar 13 '14 at 11:23

Krucamper

371
3
5

i want to count specific IDs from my tables

2 Answers2