I looked at the tutorial section to see how to get loadVars to load in data from PHP.
PHP code:
//do league queries
$query_mteam = “SELECT name FROM test ORDER BY name ASC”;
$mteam = mysql_query($query_mteam) or die(mysql_error());
$row_mteam = mysql_fetch_assoc($mteam);
$num_rows = mysql_num_rows($mteam);
$message=“hi there”;
echo “&rows=”.$num_rows;
Resulting code in flash:
loadText = new LoadVars();
loadText.load(“test.php”);
loadText.onLoad = function(success) {
if (success) {
// trace(success);
totalBox.html = true;
totalBox.htmlText = this.rows;
var newrows=this.rows;
}
};
Now I added the extra line in bold as I need to be able to use the variable I have grabbed from my PHP file using the above code (the var is called rows) and I need to be able to use this figuree to do some simple math… but I can’t seem to get it to do anything apart from appear in text fields…
I want to be able to do:
row=row+5;
for example. In fact, I want to use the value of row to generate a certain number of buttons dynamically. This eventually will be a menu based on values from a database (mySQL and PHP) but I am stumbling at the first hurdle.
Any help here?
