FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » How To » Show participants of a poll
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: Show participants of a poll [message #164568 is a reply to message #164531] Thu, 17 February 2011 10:57 Go to previous messageGo to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma:
Senior Member
Administrator
Core Developer
Ernesto wrote:
Can Vote is already in the group manager, what he wanted was to be able to see who had voted for what.


Yes, but not for "Anonymous" Razz

Rodge wrote:
A select from fudprefix_poll_opt_track with some inner joins to the polls and users is sufficient for me. Thanks!


Here's a query for you to try:
SELECT p.name AS "Poll", u.login AS "User", po.name as "Option"
FROM fud_poll_opt_track pt
INNER JOIN fud_users u ON pt.user_id = u.id
INNER JOIN fud_poll p ON pt.poll_id = p.id
INNER JOIN fud_poll_opt po ON pt.poll_id = po.poll_id AND pt.poll_opt = po.id
WHERE p.name = 'Does FUDforum support polls?';
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: How to stop giving hackers half of what they want
Next Topic: Change display order of posts
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 17:39:47 GMT 2024

Total time taken to generate the page: 0.04679 seconds