Trying to build a leaderboard.

[jample]

Hello -

I am looking to build a small leaderboard of such for my website which has a couple of games on it.

What im looking to do, is to retrieve the record, which shows which user has the most awards (most highscores). He who has the most, is the king of the arcade.

What im looking to do, is to display the top -3- users

IE:

1st place Gold
2nd place Silver
3rd place Bronze

I have it partially down, but im lost, and my code isnt the best. Can someone please have a look see and help me out? Im losing too much hair. 😃

Heres where im at:

$mosthighscores = $DB_site->query("SELECT games.highscorerid, user.username, user.userid FROM " . TABLE_PREFIX . "games AS games
				   LEFT JOIN " . TABLE_PREFIX . "user AS user ON user.userid = games.highscorerid");
while ($besthigh = $DB_site->fetch_array($mosthighscores)) {
	$mh[$besthigh[highscorerid]]['count'] = $mh[$besthigh[highscorerid]]['count'] + 1;		
	if ($mh[$besthigh[highscorerid]]['count']<$mosthigh) { }
	else {		
		if ($mh[$besthigh[highscorerid]]['count']>$mosthigh) {
		$mosthigh = $mh[$besthigh[highscorerid]]['count'];
		$mhsuser = $besthigh[highscorerid];
		$mhsarray = "";
		$mhsusername = $besthigh[username];
		} else { 
			$mhsuser = $besthigh[highscorerid];
			$mhsarray .= $mhsusername.", ".$besthigh[username];
			$mhsusername = "";
			}	
		}
	}
$DB_site->free_result($mosthighscores);

This works ok for finding 1 user ... And it works ok for checking to see if 2 users have the same number of awards, but thats it.

Thanks for any help/assistance!

[mattotto77]

I cant figure out too much what you are trying to do, are you just trying to pull out the top 3 high scores i would do do the query sort by highscore limit 0,3

this will pull out only 3 records.

[jample]

What I want to do, is take the total number of scores, and determine who has the most.

Then take that to being 3 people with the most scores together.

Need to take their username, their user id and thats it.

So the display would be like:

John, user id #92 has 50 Highscores - 1st place
Rick, user id # 16 has 32 Highscores - 2nd place
Abe, user id #148 has 12 Highscores - 3rd place.

I know my code above isnt the best, so im all for any other solution that you can help with.

Sorry for my english, it is not very well.