Getting Poll Count

[Boofo]

I'm trying to pull how many polls there are in each forum but I can't seem to get the query quite right. Can anyone please tell me what I am doing wrong?

$poll = $DB_site->query_first("SELECT COUNT(pollid) as count FROM poll
LEFT JOIN thread ON (post.threadid = thread.threadid)
WHERE thread.forumid=$forumid
GROUP BY poll.pollid
");

[Gary King]

$poll = $DB_site->query_first("SELECT COUNT(poll.pollid) AS count FROM poll
LEFT JOIN thread ON (poll.pollid=thread.pollid) WHERE thread.forumid=$forumid");

[Boofo]

Thank you, sir. ;) That did the trick. Can I use this query to also get the total voters and votes, too?

[Gary King]

Total voters and votes per poll or per forum? And don't you mean only total votes, because # of voters = # of votes, unless you mean unique voters.

[Boofo]

Which would be the best way to go? Probably total unique voters per forum? And maybe the average votes per poll per forum?

[Gary King]

Those would require some more extensive queries. Please create a query first, and when you get stuck, then reply back.

[Boofo]

It can't be done with the above query with a JOIN or something?

[Gary King]

The average votes per poll per forum:

$poll = $DB_site->query_first("SELECT COUNT(poll.pollid) AS count, SUM(voters) AS voters FROM poll
LEFT JOIN thread ON (poll.pollid=thread.pollid) WHERE thread.forumid=$forumid");

$averagevotes=$poll['voters']/$poll['count'];


Use $averagevotes wherever you need it.

[Boofo]

Ok, that works. The only problem is if you have a multiple choice poll in there the count is off for the voters.

[Gary King]

You'd have to go into pollvote for total unique voters per forum and for multiple choice polls.

[Boofo]

A whole new query, right? ;)

[Gary King]

Yep, pretty much.

[Boofo]

Ok, thanks.

[Boofo]

Mods, you can close this thread.