And how would I determine first user, second user and third user so I assign a trophy to them. Here is my full query
$getnames = $DB_site->query("predictions.*,SUM(winner) AS userwins, user.*
FROM predictions
LEFT JOIN user as user on(predictions.userid=user.userid)
WHERE predictions.winner='1'
GROUP BY predictions.userid ORDER BY userwins DESC
while ($getname = $DB_site->fetch_array($getnames)){
$wins=$getname['userwins'];
$username=$getname['username'];
$userid=$getname['userid'];
...
