count grouped results

[newb]

in my mysql query, after the results have been grouped is there any way to count the results?

 

i have a end result like this:

 

784 | x.x.x.x

754 | x.x.x.x

784 | x.x.x.x

 

so how can i count the first column after its been grouped by IPs?

 

here is my query:

SELECT * FROM `hits`GROUP BY ip

 

[tomtimms]

If you are looking to count your results, then you would use

 

$count = mysql_num_rows($result)

[newb]

i know that but thats not what im trying to do. i need to count the number of occurences for the first column. for example, im trying to get output like this..:

 

784: 2 occurences

754: 1 occurence

 

 

[tomtimms]

Well you can always use the count function if your looking to get just the first column.  Are you trying to count how many times a certain result is returned or is it just every result you want counted to see how many times it was found?

[Fadion]

As suggested, use COUNT:

 

SELECT COUNT(*) AS nr FROM hits GROUP BY ip

[newb]

yeah that doesnt work because it counts the results before it was grouped by IP, so the occurences are way off..i need to count the results after its been grouped by IP.

[newb]

so..

[newb]

bump

[sasa]

SELECT *, COOUNT(*)  AS num FROM (SELECT * FROM `hits`GROUP BY ip) a GROUP BY cullumn_name_with_numbers_784_and_so_on

[newb]

SELECT *, COOUNT(*)  AS num FROM (SELECT * FROM `hits`GROUP BY ip) a GROUP BY cullumn_name_with_numbers_784_and_so_on

 

ah...works like a charm, thanks!