Total Unique Id's with PHP and MySQL

[unemployment]

How do I total unique id's with php or MySQL.  For instance in MySQL I have...

 

ID

1

1

3

4

2

1

1

3

 

How can I total all of the 1's, all of the twos, all of the threes and so forth. 

I have four 1's, one 2, two 3's and so forth...

[waterssaz]

You mean you want to count how many occurences of each there are?

 

If so just do a simple GROUP BY query

For example

 

Select

ID,

COUNT(ID)

from

[YOUR_TABLE_NAME]

GROUP BY

ID

 

or in PHP you can use the function

array_count_values(array)

 

Hope either of these helps :-)

Regards

 

Sarah

[Maq]

It's more efficient to do this calculation in SQL than PHP.