Suckafiesh
New member
So I have a MySQL table with a whole bunch of fields, username, email, etc. There is one field in particular, called power, that I want to use to rank users against one another. For example, I want it to say
"You are Rank #14 out of 146" or something like that. How do I use PHP and MySQL to find what Rank # a person is compared to others?
I'm thinking something like
SELECT * FROM table WHERE id='$id' ORDER BY `power` DESC
but that won't tell me what rank a person is on the table will it? How do I solve this dilemma?
"You are Rank #14 out of 146" or something like that. How do I use PHP and MySQL to find what Rank # a person is compared to others?
I'm thinking something like
SELECT * FROM table WHERE id='$id' ORDER BY `power` DESC
but that won't tell me what rank a person is on the table will it? How do I solve this dilemma?