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