URLLoader annoying problem

Question

i am trying to load a variable through php from a sql database but i get nothing

here is the code

var Idfield;
var loader:URLLoader = new URLLoader();
// data will come as URL encoded variables
loader.dataFormat = URLLoaderDataFormat.VARIABLES;
loader.load(new URLRequest("pull.php"));
loader.addEventListener(Event.COMPLETE,dataload);           
function dataload(e:Event){
 Idfield =e.target.data["id"];
 trace(Idfield);
}

here is the php code

   $query = "SELECT max(id) from $tablename";
    $result = mysql_query($query) 
  or die("no rows selected");
    $row = mysql_fetch_row($result); // extracts one row
    echo  "id=$row[0]";

Answer 1

well for one thing, you need to add your event listener before you actually call load().

When you say you get nothing, what do you mean?

you can also listen for an error event and dump out any error messages from there.

HTH

Answer 2

I believe the variables format expects the variables in the name=value format so try something like:

echo 'id=' . $row[0];