mysql problem
#1

how to get player mysql id from name (GetPlayerName)?
I will rep+
thanks
Reply
#2

Change field name and table name
Код:
SELECT `FIELD NAME` FROM `TABLE NAME` WHERE `Username` = '%s'
Reply
#3

can i get player rank from top 10 list? sorry for my bad english ^.^
Reply
#4

of course you can.Change table name and if your field is not rank change it too.
Код:
SELECT `Rank` FROM `TABLE NAME` ORDER BY Rank LIMIT 10
Reply
#5

no, i mean get the player position on top 10 list.
example:
TOP NAME SCORES
1. abcd1 10
2. abcd2 9
3. abcd3 8
4. abcd4 7
5. abcd5 6
6. abcd6 5
...
to the player position exam is 10 ). how to do it
Reply
#6

Код:
SELECT `Username` FROM `TABLE NAME` ORDER BY Rank LIMIT 10
Greekz
Reply
#7

Quote:
Originally Posted by Kaliber
Посмотреть сообщение
Код:
SELECT `Username` FROM `TABLE NAME` ORDER BY Rank LIMIT 10
Greekz
no limit
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)