Simple highscore system

[Hansn]

I keep table tennis games in mysql database and want to search the database for the top ten persons with most wins. How do I tell php to get the persons int an array?
I have in my database person_a, person_b and result_a, result_b where the result tabs are the numbers of sets the players won in a game. Person_a is always the winner.

"select person_a FROM matches WHERE result_a >= 3 AND result_b < 3";

Does anyone know a simple algorithm for counting the number of times every player is in the result?

Example:

Peter
George
Peter
Peter
George
Simon
Abraham
Simon
Peter
George

should result in Peter 4, George 3, Simon 2, Abraham 1

[Shrike]

[MAN]array_count_values/MAN perhaps?

[mrhappiness]

SELECT person_a, COUNT(person_a)
FROM matches 
WHERE result_a >= 3 AND result_b < 3
GROUP BY person_a

?

[Hansn]

Originally posted by mrhappiness

SELECT person_a, COUNT(person_a)
FROM matches 
WHERE result_a >= 3 AND result_b < 3
GROUP BY person_a

? [/B]

Great! Thanks, that codeline did the whole job! I thought there would be some cool mysql-statement to call, I just didn't know about it.

Thanks!