LiveCode Forums

Thanks, took a bit of time to find all of the correct boxes to tick but it now works!

Hi everyone,
I am creating an app which uses an SQL database. When I run the code on my phone it stops working when I try to make a connection with the database, I have run the code on my computer and it works. Any suggestions?
Thanks
Matthew

In the end I did it slightly differently, as I realised that I wanted to do the ranking in a slightly different way that isn't possible with MySQL. For anyone's future interest here is my code with the table and column name emited: put "SELECT * FROM " & tTableName & " ORDER BY tColumnName DESC" int...

I have entered it, and it returns this error code:
revdberr,You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '‘rank’, p.* from tTableName p, (SELECT @rownum:=0) r order by Score desc' at line 1

Thanks, I wandered if this was possible
How would I include these in my code?
Thanks
Matthew

Hi, I have a datagrid which downloads the contents of a MySQL database table, this is downloaded with the entries in no particular order. The table has a name column and a score column. In the datagrid I want it to be sorted by the score (descending). This can be done easily, but here comes the prob...

Simon,
I have tested your suggestion just using a field rather than saving the results to a file, however I was hoping to be able to create a leaderboard which contained all entries, not just the top 3. Sorry if I caused confusion.

Thanks Simon, to clarify I want a leaderboard which can be updated which appears within the app. Could you please provide some guidance on how I would do it with SQL, I know there are lessons on how to upload etc. but how would I insert the records, as if it was listed in the correct order on mySQL ...

Thanks, but unfortunately this is only for iOS, and I am currently mainly developing for Android so this wouldn't work. I am going to move onto iOS hopefully and I would then use this, but currently I don't have a Mac so can't develop for iOS. Does anyone have suggestions for Android?
Thanks
Matthew

Would anyone be willing to provide some guidance on this, as although I am quite proficient in coding I am not confident with databases and webpages etc. Even just to maybe explain the structure of how I should run it, as I don't want to have to overcomplicate my app if it means having to download a...

Hi everyone, I have been creating a game for Android and I would like to implement a public leaderboard. I was wandering if anyone could offer any suggestions in how to go about this. The ideal one would be to be able to use google play services, as this could then also be used for iOS, however I do...

Hi everyone, I have created a game which is designed for mobile. For this I want to implement a high score system, this needs to be both local and also public: 1) Local - I know that this should be quite easy, I have tried to save the stack, using a splash stack with the other stack attached, shown ...

Thanks, I got that to work, I wasn't sure where to find the font files, so I found it easiest just to download one from online.

Thanks Simon and Dixie As far as I can see both of your suggested codes are very similar, is there any advantages to one over another? On a slightly unrelated point when I did transfer the app to my phone all off the fonts which I had set had been lost, is there any reason for this and a way to solv...

Instead of 'wait 1 second with messages', try... wait 0 millisecs with messages if all you are wanting to do it wait for the liveCode engine to execute everything Hi Dixie, I still want to keep the waiting for 1 second as I need to count down for 30 seconds, so I don't think this would work. If I d...