[maza51]

Thank you.

But this only shows the top. And if I want to learn rank?

I've been using for the top 10

Format(query, sizeof(query), "SELECT * FROM 'Rank' WHERE points ORDER BY points DESC LIMIT 0, 10");

For rank

Format(query, sizeof(query), "SELECT * FROM 'Rank' WHERE steamId ='%s'", steamId);

But I can only learn Points...

It is necessary to write:
You are a 35 place out of 300.. in statistics.

[FaTony]

You will have to sort.

[maza51]

Originally Posted by FaTony You will have to sort.

I do not understand

[Master53]

example

SELECT NAME,steamId FROM `Player` ORDER BY POINTS DESC LIMIT 0,10

"Points" is the field from the database table "Player" this fetches the top 10 including 0 players from that field who has the most points...

this code gets fetches the players points from there steam id to.

[maza51]

It works for me fine. How do I know in what position I'm in the statistics, if I do not have the top 10??

[Master53]

what are you using to display the top 10?

[FaTony]

Query all entries in DB and find your one, storing it's index.

[maza51]

Originally Posted by Master53 what are you using to display the top 10?

SELECT * FROM 'Rank' WHERE points ORDER BY points DESC LIMIT 0, 10

[maza51]

Originally Posted by FaTony Query all entries in DB and find your one, storing it's index.

http://forums.alliedmods.net/showpos...1&postcount=11
!!!!!

[FaTony]

Select without limit.