php / mysql / flash

Anon

I have a high-scores table in a flash movie. I am able to load data from a mysql table using php. In flash, I use the line:

movieclip.loadVariables("dbfile.php", "Get");

However, after loading, this information is cached somewhere. I can then go to any other portion of the flash movie and come back to the frame that loads the variables from the database, but nothing has changed. (after I have changed some of the database information).

How can I refresh the flash scores table each time it is viewed without it caching the information?

thanks

Anon

I don't Know if this will help you but I had something similer happen to me when I was working on a counter.

This is taken from a tutorial that helped me.

"In the First frame of the Movieclip add the following actionscript:

loadVariablesNum ("PHPCounter.php?ran="+random(9), 0);

This is illustrated Below - By adding the random(9) onto your site you create a unique file each time, if you left this out you would load the same php script that is in the cache and the file would not be updated - you may want to increase the 9 to 99 or even 999 - it doesn't matter for this tutorial or this counter in general: "

and here is the link to the tutorial

http://www.flashkit.com/tutorials/Dynamic_Content/Simple_P-Jeffrey_-656/more3.shtml

hope that helps

whizkid

Hi,

I don't know if this will work, but you can try to add some none cache headers to that PHP file:

header ("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); // Date in the past
header ("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // always modified
header ("Cache-Control: no-cache, must-revalidate"); // HTTP/1.1
header ("Pragma: no-cache"); // HTTP/1.0

firemouse2001