Order by count of same values

[theunreal]

Hello
I have table with the following:
id| name | value

I would like to show results with PHP of the records with the most same values
For example:

1|test|value1
2|mmimi|value1
3|mfdmdf|value2

it will show:

value1|2
value2|1

the number above is the number of records with the same value (value1,value2).

[r937]

SELECT value
     , COUNT(*) AS howmany
  FROM daTable
GROUP
    BY value
ORDER
    BY COUNT(*) DESC LIMIT 1

[theunreal]

@r937

SELECT value
     , COUNT(*) AS howmany
  FROM daTable
GROUP
    BY value
ORDER
    BY COUNT(*) DESC LIMIT 1

Thank you very much, it works great.