Need help with MySQL for a leaderboard

[TubooBokBok]

Hello. I have been working on an android app and am now trying to implement a global leaderboard where high scores are saved.

Pretty much I want my app to retrieve a list of the top 50 scores, compare them to see if the users new score is better then any of them, if so place it in the leaderboard and re-order the scores. The top 50 scores would also be displayed in the app.

My question is should I use MySQL for this and if so how would I go about it? I have read the Runrev tutorials but I cannot follow them becasue I have no knowledge of how MySQL acctually works and how I could change their code to meet my needs.

Any help is greatly appreciated. Thanks.

[sefrojones]

HI,

I made a simple game/stack with a MySQL high score board, The full stack (minus my DB info) is available in this thread: (Scroll down, it is in the LAST mega link I posted)

http://forums.livecode.com/viewtopic.php?f=22&t=19380

The script that handles the database is in the button "done" of the group "entername" you can add your own mysql database info there.

You can set up a quick free MySQL database to test it out at :

http://www.freesqldatabase.com/


--Sefro

[TubooBokBok]

Thank you very much!