Hi Guys,
I have a mysql table like below:
id name points
1 john 4635
3 tom 7364
4 bob 234
6 harry 9857
I basically want to get an individual user rank without selecting all of the users. I only want to select a single user by id and get the users rank which is determined by the number of points they have.
For example, get back tom with the rank 2 selecting by the id 3.
Cheers
Eef