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 #167740 is a reply to message #164568] Tue, 11 September 2012 10:00 Go to previous messageGo to previous message
pips is currently offline  pips   Ireland
Messages: 113
Registered: February 2012
Karma:
Senior Member
naudefj wrote on Thu, 17 February 2011 10:57
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?';



Hello chaps.

So, i'm trying to to do what the OP wanted to do and show who is voting in a poll.

I put the above SQL query into the SQl thing and got a heap of red text. Confused

Does this still work for 3.04?

I just cut and pasted it and then hit "Run query" Did i do it wrong?


any help appreciated...
[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: Fri Nov 01 06:19:09 GMT 2024

Total time taken to generate the page: 0.03276 seconds