[mysty]

I'm trying to query for the rank of a player and set it as a cookie.
I'm new to SQL and I still have no idea what's the correct way to query the rank for a player.

SQL Table:

steamid            || name              || score
[U:1XXXXX]          Player X             213
[U:1XXXXX]          Player U             13
[U:1XXXXX]          Player Y             437
[U:1XXXXX]          Player Z             578
[U:1XXXXX]          Player W            487

To determine the rank, I reorder the score by descending order and count the row.

I've been trying various like
SELECT COUNT(*) OVER(ORDER BY score DESC) FROM ranks WHERE steamid = %s", clientid

or

SELECT COUNT(*) FROM ranks ORDER BY score DESC WHERE steamid = %s", clientid

What is the proper way to find out the rank of the player?

[neatek]

Originally Posted by mysty What is the proper way to find out the rank of the player?

Usually tables have PRIMARY KEY -> id.
For every player you can store this ID.

PHP Code:

SELECT count(id) FROM ranks WHERE id < 10
// 10 - it's ID of player. (PRIMARY KEY) 


So you can get rank of player

[mysty]

Originally Posted by neatek Usually tables have PRIMARY KEY -> id. For every player you can store this ID. PHP Code: SELECT count(id) FROM ranks WHERE id < 10 // 10 - it's ID of player. (PRIMARY KEY)  So you can get rank of player

Hmm I think you misunderstood, I'm trying to get the rank by the points they have. Sorry if I did not clarify properly.

[Miu]

I think it'd be "SELECT COUNT(*) FROM ranks WHERE score >= %d ORDER BY score DESC", where %d is the client's score

[neatek]

Originally Posted by Miu I think it'd be "SELECT COUNT(*) FROM ranks WHERE score >= %d ORDER BY score DESC", where %d is the client's score

better

PHP Code:

SELECT COUNT(score) 


it maybe faster