If you go to http://www.silvernova.co.uk/highscore.php you can see that it has been added.. you can change the name and score in the address above and see that it has been added to the table and will be in highscore.php.
SO, the problem must clearly lie with the game? Right? :S
addscore_sq.php gives me error 500, maybe that's got something to do with it
Hah, I don't know much MooSock, it looks okay to me. If you're really desperate, you could just use Browser object to open that URL in the user's default browser.
You don't have a space in between your POST command and the URL - get rid of the " + " and put a space in instead. I also don't think you need the "HTTP/1.0" at the end - it's always worked without it for me. If you do leave it in, put a space in before it - otherwise it will probably be treated as being added to the Score field.
If you want to verify that your data is being sent, don't disconnect after sending but listen on port 80. Then, On Received, set the text of an edit box to Edittext$("Edit Box") + RecvLine$("MooSock"). This will display the text output from the PHP page, if there is one.
Going to the addscore page gives a server error for me as well.
What I'd do there is put in some echo commands to let you know what the PHP thinks is happening - at the moment, nothign is output as long as the MySQL connection works. Try putting in echo ($name . ", " . $score . ", " . $game_id) or something similar just after you've set those variables - that way you'll be able to tell what's going into the database.
Build up the query in a separate string as well and echo that just before you run it:
Finally, I can't see anywhere that you're passing anything called "game_id" to the PHP page - I don't think this should prevent it from working, though.
It would, because nothing is being entered in that field, so it would either return an error, or put nothing there... but that means nothing could be got for the game
There almost seems to be nothing at all preventing this from working...... its pathetic and extreeeemely frustrating and annoying. The php works fine because you can enter the (adding the score) address from a browser and it works fine. Its either just not connecting or sending info or accepting something but i just dont know WHAT!!!!!!
I put together a small application to send the data to your page, and it's working fine for me. Have a look and see what's different from the events you have already.
WOOOOOOOOOOOOOOOOOOOO Thanks Wong, though I have been using MMF1.5 to make this game, I'm gunna have to switch over to mmf 2 now anyway whilst following your example..
I guess somehow it prefers to get text from an edit box rather than a string or counter... As I set the other two edit boxes you created to "1" for the ID and Global Value A for the other edit box, and it worked fine!!!
Many thanks You can expect your name in the credits of Squidge