Counting Records with matching field

[struth]

I'm trying to count the number of comments made by a specific user.

EG
SELECT COUNT(UserID) AS CommentNumber
FROM UserComments

Presently of course all I get is the total number of comments and not the number of comments made by each user. The UserID starts from 1 and rises.

tia
Struth

 

[Guest_imported]

SELECT COUNT(UserID) AS CommentNumber
FROM UserComments
WHERE UserID = 1 'the user u wish to count for

 

[struth]

Thanks, but what I'm after is an output like this:

USER | NO OF COMMENTS
-----------------------
User1 | 6
-----------------------
User2 | 2
-----------------------
User3 | 4
-----------------------

Etc

Struth

 

[rico14d]

select user_id, count(comment_no)
from UserComments
group by user_id

 

[struth]

Thanks but this gives me an error - too few parameters

So I tried this

SELECT UserID, COUNT(*) AS CommentNumber
FROM UserComments
GROUP BY UserID;

No errors as such but it still didn't come up with what I wanted - it just came up with one UserID CommentNumber repeated.

Any other ideas?

tia
Struth

 

[struth]

This last one actually worked ... problem was somewhere else.