[10101010]

Originally Posted by vitorrd Excuse me if your brain is not capable of expressing what you want correctly. Suit yourself.

Are you talking seriusly? Where do you read the word XP? I said rank, which is what I want.

I don't want to start a flame war but please read the post twice next time

[vitorrd]

Originally Posted by 10101010 Are you talking seriusly? Where do you read the word XP? I said rank, which is what I want. I don't want to start a flame war but please read the post twice next time

If you knew anything about programming you'd know the position of something in a "list" is called index, not rank. But, as you said, not here to start a flame war.

[Exolent[jNr]]

SELECT * FROM `table` ORDER BY `xp` DESC

[vitorrd]

Now call the moderator a retard, I dare you.

@Exolent: His point s to get the index of a row to see how good/bad a player is doing.

[Exolent[jNr]]

Once you have the results of that query, getting the rank isn't that difficult.
Pseudo Code Example:

SQL Query: SELECT `name`, `steamid`, `xp` FROM `table` ORDER BY `xp` DESC

rank = 0
name = ""
xp = 0

row = 1
results = SQL RESULTS

while row <= results
    READ RESULT 1 steamid
    if equal steamid "specific player steamid"
        READ RESULT 0 name
        READ RESULT 2 xp
        
        rank = row
        break loop
    
    row++

if rank > 0
    print name, steamid, xp