Hoping someone has a solution to what I think may be a simple problem. I am just trying to get variable from a mysql database to show in Flash for testing purposes, but with no success. I have looked all over (including this forum) for solutions but no luck. The php file works for sure because I just went straight to the php file in the url and the result shows up, so I don’t think the problem is there. And I was able to insert variables into mysql via php with no problem on some other files I have created. Anyway, here is the php:
$sql = mysql_query(“SELECT * FROM scores ORDER BY uid DESC”);
$row = mysql_fetch_array($sql);
$name = $row[“name”];
print “var1=$name is in database.”;
And here is the actionscript. :
var varSend:URLRequest = new URLRequest(“http://www.mysite.com/test/getresults.php”);
varSend.method = URLRequestMethod.POST;
var varLoader:URLLoader = new URLLoader;
varLoader.dataFormat = URLLoaderDataFormat.VARIABLES;
var phpVar= event.target.data.var1;
//print out result in text field with instance name of mText
mText.text = phpVar;
I just have a feeling the solution is very simple and I have just overlooked it.
Any help would be greatly appreciated.