Display position in mysql

[sowh4t]

I need a script that selects all from mysql, orders them DESC with highest money and prints out only where username=$_SESSION['username'],
so it will show
Your position is X/10

[Biiim]

<?php 
$Q = "SELECT * FROM `mysqltable` ORDER BY `money` DESC";
$R = mysql_query($Q);
$i = 1;
if($R !== false){
    while($row = mysql_fetch_assoc($R)){
        //echo "{$row['username']} is position number {$i}<br/>\r\n";
        if($row['username'] == $_SESSION['username']){
            echo "You are position number {$i}<br/>\r\n"; 
        }
        $i++;
    }
}else{
    echo "no results returned :".mysql_error();
}
?>

[sowh4t]

thanks a miljon!