Ranking

Hello. I am creating stats for my game, but I don't know HOW to do it. Please help how can I find my rank? I want to make it optimalized, but I don't know how

If I select it like this

SELECT username, id, password FROM users WHERE population >= $mypopulation

and then count number of results, I get my rank, but I do not know how to get which others ids I have to select

 

While it might not be what you are asking for but as a tip - do not try to obtain useless data; what for do you need password value in this case ?

 

in this case, for nothing I was sorting it by passwords because I don't have got population system

 

problem is not in details, unable to understand.

 

I can only assume from what you've said that you're only counting the data from the first result, so it will only return 1 result.
Are you looping it? That will loop through the results and display all....

 

I got it. thanks anyways