you can also use backslash

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

but it looks a little oddly