This is a very simple version of a PHP high score list, but is very easy to edit yourself and make changes.
PHP Flash High Score Tutorial
February 2nd, 2010 
phpmoz 
Posted in 
Tags: 
February 2nd, 2010 phpmoz This is a very simple version of a PHP high score list, but is very easy to edit yourself and make changes.
I apologize for the late response, I didn’t notice you replied again… I think to be on the safe side, you should always close a connection, but I will admit that I don’t do it half the time and haven’t run into any major problems.
actually should mySql close connection be used after the scores have been received?
mysql_close – or is it unimportant because its not a persistent connection?
ah i just figured it out. When I connected to mySqlAdmin I connected correctly there but I’d put the name of the table in where the name of the database should have been and it screwed everything up. It works perfectly now
going to move on to the next part of the tutorial
it shouldn’t be… It is being set to the results… It should equal 1 if it is returned correctly… which would make it go through the while loop…
it works fine for me still… the only think i could think of is to set it to 0 above…
$line = 0;
just put it at the top so it is initialized… otherwise i would look up the error in google and see what results you get
is $line an undefined variable?
I’ve already connected properly to the database. I played around with it initially and got disconnected errors so I returned it to the way it was and the errors disappeared so I am connected to the database I’m pretty sure
If you check, I failed to add in the connect to database in the code, because i was filling in my own… so add this code and it should work fine…
$link = mysql_connect(SERVER,USERNAME,PASSWORD);
mysql_select_db(DATABASE NAME);
Add those lines in at the top of the PHP code and it should work fine, fill in the all caps variables first
Hey I used your code but I keep getting errors
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [filepath].scores on line 9
I’ve connected my database and made the for loop.
I think it has problems with if($line = mysql_fetch_assoc($results)){
I get $line an undefined variable when I play around
Any such luck? Going to look at your other videos now
hey, new video is up, enjoy!
@projectfinale
THANKS!
Can you Reply this comment when u have uploaded ?
yup no problem, ill post a second video in the next few days
Hey Babeee!
Can you tell me how I put score from flash game into mysql ? …. btw. I know PHP and mysql. Just thinking how I do it in Flash
maybe can u tell me also how I connect Online User into the Flash? Like Automatic insert when he-she top the highscore?
[...] See the article here: PHP Flash High Score Tutorial | PHP Blog [...]
[...] more: PHP Flash High Score Tutorial | PHP Blog Share and [...]
[...] the original here: PHP Flash High Score Tutorial | PHP Blog Share and [...]
[...] is the original post: PHP Flash High Score Tutorial | PHP Blog Share and [...]
[...] here to read the rest: PHP Flash High Score Tutorial | PHP Blog Share and [...]
[...] More here: PHP Flash High Score Tutorial | PHP Blog [...]