mysql problem - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: mysql problem (/showthread.php?tid=566351)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: mysql problem (/showthread.php?tid=566351)
mysql problem - davidbull - 05.03.2015
how to get player mysql id from name (GetPlayerName)?
I will rep+
thanks
Re: mysql problem - MikE1990 - 05.03.2015
Change field name and table name
Код:
SELECT `FIELD NAME` FROM `TABLE NAME` WHERE `Username` = '%s'
Re: mysql problem - davidbull - 05.03.2015
can i get player rank from top 10 list? sorry for my bad english ^.^
Re: mysql problem - MikE1990 - 05.03.2015
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
Re: mysql problem - davidbull - 05.03.2015
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
AW: mysql problem - Kaliber - 05.03.2015
Код:
SELECT `Username` FROM `TABLE NAME` ORDER BY Rank LIMIT 10
Re: AW: mysql problem - davidbull - 05.03.2015
Quote:
|
Originally Posted by Kaliber
 Код:
SELECT `Username` FROM `TABLE NAME` ORDER BY Rank LIMIT 10 |