List of users who have replied to a thread

[graham_w]

Hi

I run some competitions on my forum, where the only stipulation is that the user replies to the thread to enter. What I would like to be able to do, is create a list of all the usernames who have replied to a particular thread by using something perhaps as simple as an SQL query.

What I currently do is go through the thread and cut and paste names of people who have replied and enter them into a randomizer of some description and pick a random winner. This request for a list of names will cut down on the manual work.

Is someone able to assist with the necessary SQL syntax to use to create this list ? Or suggest another way to do what I am after ?

Thanks
Graham

--------------- Added [DATE]1237880957[/DATE] at [TIME]1237880957[/TIME] ---------------

After a bit more searching, i can't believe how easy this is.

Click on the number of replies and it brings up a list of users and the number of times they have replied. I've used vBulletin for a few years now and never realised that existed