Counting number of columns with the same number

[therocker]

Hello, I can't seem to be able to count the number of rows that have the same numbers.
 
For example, in column forums_id, if the column contains 3 then count all of them with the number 3. If column contains then count all of them with the numbers 2. Here is what I mean.
 

 
Is there a way to do that? I've got something like this.

SELECT count(*) as forums_counting FROM forums_comment WHERE forums_id = '$forums_id' GROUP BY forums_id

[cataiin]

SELECT count, count(*) as forums_counting FROM forums_comment WHERE forums_id = '$forums_id' GROUP BY forums_id

[Barand]

cataiin - where is column "count" coming from?

 

therocker - exactly what problem are you having. Apart from the GROUP BY which is OK but unnecessary if you are selecting a single id it should work (so long as $forums_id contains a valid id. Try

SELECT forums_id,  count(*) as forums_counting 
FROM forums_comment  
GROUP BY forums_id

to get a count for each forum

[cataiin]

cataiin - where is column "count" coming from?

I tried the code on localhost first time and I was wrong when I changed the values. Sorry!

He just needs to modify the first count with forums_id in my code.

[therocker]

Thanks guys. It's working now. How do I change this topic to Resolved?