Select Code to Download

$sth = $dbh->prepare('Select @rownum:=@rownum+1 rank, p.* from player 
+p, (SELECT @rownum:=0) r order by score desc limit 10');