Hard Query

[matt_4013]

Hiya people. I have a mysql database, with 3 tables in it. A games table, users table, and a votelookup table. The intent of this database is for the users to be able to add their vote for a particular game, via a php web application. When the user votes for a game, a unique record is created for the vote, with the fields, vote_id, user_id, game_id, and date. I want a query that will count all of the votes for each game, and output the number of votes per game, and the games details (obtained from the games table). How could I do this?

I've attached a layout of the database for reference 🙂

Thanks a lot,
Matt

[matt_4013]

heh, turns out it wasn't so hard . . . Well, it was for me 😉

select games.*, count(votelookup.game_id) as vote_count from games,votelookup where games.game_id=votelookup.game_id group by votelookup.game_id ORDER BY vote_count DESC LIMIT 0,100;