Find current ranking?

PHP
1

Is there an easy way to find the current ranking of an user?

I have an db table with the users id an the amount of points (fk_user_id,points).

Now, I want to find out what the current users rank is from the points… How do I do that? the points can also be minus(-). The higher the points the better ranking…

Any ideas to where to start…

2

Oh yes… I got it myself:

$sql = mysql_query("SELECT COUNT(*) rank FROM ".$prefix."_users WHERE points > (SELECT points FROM ".$prefix."_users WHERE id = $currplayer) AND played > 0");

Sorry for the trouble…