Results 1 to 10 of 10
Thread: Most votes (sub-queries maybe?)
Feb 7, 2006, 19:34 #1
- Join Date
- Aug 2003
- 0 Post(s)
- 0 Thread(s)
Most votes (sub-queries maybe?)
Well I need help with this one...
I want to select the members ID with the most votes.
Table: "leader_votes"`ID` mediumint(8)`MEM_ID` is the members ID who is voting
`MEM_ID ` mediumint(8)
`galaxy ` tinyint(3)
`planet` enum('1', '2' ... '20')
`vote_for` is who the above member is voting for
I want to select the members IDs (vote_for) with the most votes in a specific galaxy and planet - galaxy and planet are supplied by me.
If you need anymore information just ask.