PHP列表组合了类似的值和计数值

I have a column in a MySQL database that has values such as: Value A [next row] Value B [next row] Value C [next row] Value A [next row] Value B [next row] Value C. I want each similar value to be combined and the number of times it appeared, such as: 2 (x) Value A, 2 (x) Value B, 2 (x) Value C. Thank you!

It sounds like you want a histogram. You should perform a query like:

select value, count(*) as count from table group by value

Here is a SQLFiddle demonstrating the database query