Get the second best SQLite score
#1

Hello, well, I have a doubt, here, in this code that I leave you I get the first 15 users of the table, that is, the top. What I want to know is how I get the stats of the second best user, and the third and so, but only individually and not all together and ordered, I do not know if I explain, thank you.

Код:
format(Query,sizeof(Query),"SELECT `Nick` FROM `Usuarios` ORDER BY (`Score` * 1) DESC limit 15");
resultado = db_query(BaseDeDatos,Query);
For example the first best "score" would go in this textdraw

Код:
Textdraw5 = TextDrawCreate (122.234283, 356.492949, "[S] peed_.");
TextDrawLetterSize (Textdraw5, 0.199341, 1.337499);
TextDrawAlignment (Textdraw5, 1);
TextDrawColor (Textdraw5, -1);
TextDrawSetShadow (Textdraw5, 0);
TextDrawSetOutline (Textdraw5, 1);
TextDrawBackgroundColor (Textdraw5, 51);
TextDrawFont (Textdraw5, 2);
TextDrawSetProportional (Textdraw5, 1);
Reply


Messages In This Thread
Get the second best SQLite score - by BrianFaria - 24.11.2016, 12:27
Re: Get the second best SQLite score - by Konstantinos - 24.11.2016, 12:41
Respuesta: Get the second best SQLite score - by BrianFaria - 25.11.2016, 05:02
Re: Get the second best SQLite score - by Vince - 25.11.2016, 07:24

Forum Jump:


Users browsing this thread: 1 Guest(s)