Everything works exept when I change any information in mysql and then run the actionscript the new data isn’t loaded I am seeing the previous data. It’s not updating. Can someone one please explain to me what I am missing?
When I shut down flash CS5 and reopen it then rerun the actionscript I get the new information. But I should be able to load the new information without having to shutdown flash and reopen it.
Thank you.
I have the following code in my actionscript:
import flash.display.MovieClip;
import flash.events.;
import flash.net.;
var request:URLRequest = new URLRequest(“http://localhost/Game.php”);
request.method = URLRequestMethod.GET;
var loader:URLLoader = new URLLoader();
loader.dataFormat = URLLoaderDataFormat.VARIABLES;
loader.addEventListener(Event.COMPLETE, completeHandler);
loader.load(request);
function completeHandler(evt:Event) {
var pointsVar = evt.target.data.points;
var slootVar = evt.target.data.sloot;
var dartVar = evt.target.data.dart;
trace ('Points is ’ + pointsVar);
trace ('Sloot is ’ + slootVar);
trace ('Darts are ’ + dartVar);
}
The php script looks like this:
<?php
$username=“Sean”;
$points="";
$sloot="";
$dart="";
include ‘connect.php’
$query = “SELECT * FROM whatever where User=’$username’”;
$result = mysql_query($query);
$row = mysql_fetch_array($result) or die(mysql_error());
$username= $row[‘User’];
$points= $row[‘Points’];
$sloot= $row[‘Sloot’];
$dart= $row[‘Darts’];
echo “User :$username <br>”.
“Points :$points <br>”.
“Sloot :$sloot <br>”.
“Darts :$dart <br>”;
$returnVars = array();
$returnVars[‘username’] = $username;
$returnVars[‘points’] = $points;
$returnVars[‘sloot’] = $sloot;
$returnVars[‘dart’] = $dart;
$returnString = http_build_query($returnVars);
//send variables back to Flash
echo $returnString;
?>
