PHP/Flash problem

[Anon]

Hi,

Im working on a hi-score board in flash using PHP to add & retrieve the data. My problem is that the loop in the script doesnt work in the *.swf, all it displays is the first record.

This is the code;

<?php
require("func_connect.php");
connect ("localhost","coasters");

if(isset($score)) {

//If score exists enter into DB
$sql = "INSERT INTO coasters (score,name) ". 
       "VALUES ('$score','$name')"; 
$result = mysql_query($sql);
echo "Your hi-score has been added!";

}

else {
$result = mysql_query("SELECT * FROM coasters ORDER BY score desc LIMIT 10");
if ($details = mysql_fetch_array($result)) {

$fl_name = $details["name"];
$fl_score = $details["score"];

             do {
             echo ("&fl_name=$fl_name");
             echo ("&fl_score=$fl_score");   } 


       while ($details = mysql_fetch_array($result));
       } 

else {
echo "No scores at this time.";
}

}
?>

Do I have to loop in Flash? Any help would be greatly appreciated.

Thanks,
dast

[Anon]

Here:

echo ("&fl_name=$fl_name");
echo ("&fl_score=$fl_score"); }

The end result of that is

&fl_name=a1&fl_score=10&fl_name=a2&fl_score=20&fl_name=a3&fl_score=30&fl_name=a4&fl_score=40

so when Flash gets it, it'll only create one of the fl_name and fl_score variables. So you have to rename them to be something like this:

&fl_name1=a1&fl_score1=10&fl_name2=a2&fl_score2=20&fl_name3=a3&fl_score3=30&fl_name4=a4&fl_score4=40

that way Flash will get all 4 variables (or in your case, 10)

Actually, I don't know much about Flash, but this is my guess on what's wrong.

Diego

[Anon]

Thanks a lot mate 🙂