Sorry, I was under the impression that you had some knowledge of database operation.
Okay, you see in this image:
towards the bottom where he has the parameter $sql="SELECT * FROM scores ORDER BY score DESC LIMIT 10"
You simply need to remove the "LIMIT 10" and it will return all of the scores in the database ordered by score descending.
That is what that select statement is asking for:
SELECT (tells the database to get data)
* (tells it to return all data)
FROM scores (from the "scores" table)
ORDER BY score (order the data lexicographically by score)
DESC (in a descending order from highest to lowest)
LIMIT 10 (only return the top 10 scores)
> How can I turn it to use 3 columns instead of 3.
Also this question makes no sense.
Thanks a lot Gumshoe for such details replay, really really helpful and I understood that removing the limit of 10 will display all results. But in sample capx creator is using array and I have made it 10x10 to display data in 5 lines in text boxes. If I will try to show all list (might be scrolable) then how it can be done (I think it needs to create scrollalbe list with data filling from server, right)? any help in this? To cut short the things I am sharing screenshot of leaderboard similar to my requirement. I will be very thankful to you if can help me in getting close to this.
Regarding colum 3 to 3 statement, it was my mistake. Actually creator is using 2 column (through array) and I need 3 colmn (index no. , player name, score). Also explaining this through screenshot.
waiting for your reply. below is screenshot of required leader board and question which I have.