Hello,
I am trying to load multiple records from MySql/php to flash.
I can get one record to display but not sure how to do multiple records.
Heres what I have so far...
$calculation = $_POST['dyears'];
$result = mysql_query("SELECT * FROM artists WHERE artname ='$calculation'");
if($row = mysql_fetch_array($result)){
do{
echo "&returnVal=".$row['imgpath'];
}while($row = mysql_fetch_array($result));
}
here is what I have in flash
stop();
var lvOut:LoadVars = new LoadVars();
var lvIn:LoadVars = new LoadVars();
lvIn.onLoad = function(success) {
if (success) {
output = lvIn.returnVal;
} else {
output = "fail";
}
};
myBtn.onPress = function() {
lvOut.dyears = "Dan";
lvOut.sendAndLoad("http://www.liquidesignz.com/nwjv/dogyears.php", lvIn, "POST");
};
Any direction would be appreciated!
liquid