Help with SQL statement

[gamew0rld]

I have a table that has 4 fields. An autoincrement field (id), member_id, game, and date. Every time a user plays a game, a record is added to this table. I want to grab the 5 most played games for each member(member_id). Does anyone know how I can do this?

[pha2er]

SELECT count(game) AS a, game FROM table GROUP by game ORDER BY a DESC LIMIT 0,5

that should do it!