[RESOLVED] Total Contributors.

[Smurlos]

Hi there. I'm working on an faq based site whereby people sign up, ask questions and then people who know stuff about that topic are able to reply. People that reply are called contributors.

I have a table called "answers" as follows:

AnswerID
QuestionID
UserID (person posting the question)
Question_UserID (The person the question was first posted by)
AnswerText
PostedDate
ReadByUser

Say I had 20 answers. 10 from userid 1, 5 from userid 2, 5 from userid 3.

I want to do a total number of contributors. So the total number of people who have posted a reply. It should say 3 contributors. How would I modify my selector query so that it would come up with an answer of 3?

Thanks for your help in advance.

[laserlight]

It would be something like:

SELECT COUNT(DISTINCT UserID) FROM answers

[Smurlos]

laserlight;10894298 wrote:

It would be something like:

SELECT COUNT(DISTINCT UserID) FROM answers

Aha, DISTINCT! I've been out of the game for a few years and I just could not think of the word... I was using UNIQUE... haha.

Thanks 🙂

[laserlight]

You're welcome 🙂
Remember to mark this thread as resolved using the thread tools.