Count Distinct Values

[eval(BadCode)]

I want to select distinct values, and the count of the distinct values.

An example table would be:

field
+-------+
|   A   |
|   A   |
|   B   |
+-------+

I want my query to return:

| field | count(field) |
+-------+--------------+
|   A   |      2       |
|   B   |      1       |
+-------+--------------+

I've tried permutations of count(distinct(field), field etc etc but I just end up with one row- when from looking at SELECT *, I can clearly see the query I'm wanting returned should have at least 100 rows.

Edit: I know I can do this with php or two queries/stage table, but this really should be a 1 query thing.

[eval(BadCode)]

Turns out I got it. I tried a sub-query but the number of rows didn't match up, so I fell back on my googlefu and found an answer.

SELECT DISTINCT table.field, Count(table.field) as Number 
FROM table 
GROUP BY table.field