Leaderboard in App

[netsolutions1 (Muhammed Rafeeq)]

Help me for making Leaderboard using mysql in kodular. Here is sql

How convert it to kodular blocks please…

SELECT @rank:= @rank + 1 as rank, s.* FROM ( SELECT field1, field2, … FROM players, (SELECT @rank:=0) r ORDER BY score DESC LIMIT 25 ) s

[ImranTariq]

this amazing Tutorial on Mysql by @Taifun will help you to learn.

https://puravidaapps.com/mysql.php

[Taifun]

@netsolutions1

SELECT @rank:= @rank + 1 as rank, s.* FROM ( SELECT field1, field2, … FROM players, (SELECT @rank:=0) r ORDER BY score DESC LIMIT 25 ) s

a simple

SELECT player, score FROM players ORDER BY score DESC LIMIT 25

will do it
you might want to learn how to work with lists to be able to process the result

• How to work with Lists by Saj
• How to work with Lists and Lists of lists (pdf) by appinventor.org

Taifun