Help with Loading XML Data embeded in PHP in Flash List Component

programming flash
1

Hello all,

I’m trying to load xml data embeded in php into a listbox component. I have a piece of code that just loads the xml but does not display it in the list box

<code>
var yourXML:XML = new XML();
yourXML.ignoreWhite = true;
yourXML.onLoad = function(success:Boolean) {

var nodes = this.firstChild.childNodes;
for(i=0; i&lt;nodes.length;i++) {
  yourListBox.additem(nodes*.firstChild.nodeValue,i);
  }
if (success) {
	
    trace("XML Loaded Successfully");
    trace("XML File Contains "+"

"+this);
} else {
trace(“XML Failed to Load”);
}
};

yourXML.load(“get_data.php”);
</code>

Can anyone tell me where the problem may be. I would really appreciate it thank you

please note that the flash version is Profesisonal 8

the content of get_data.php is

<code>
<?php

//connect to the local MySQL
$conn = mysql_connect(“localhost”, “username”, “password”);

//select your database
mysql_select_db(“database”);

//query the database
$query=“select * from table order by tablestate, tablename”;
$result=mysql_query($query);

//loop through and write the data into variables for the flash document with XML

echo "<?xml version=“1.0”?>
";
echo "<hospitals>
";

while($row=mysql_fetch_assoc($result)) {
echo “<name>” . $row[“tablename”] . "</name>
";
echo “<state><strong>” . $row[“tablestate”] . "</strong></state>
";
}

echo "</hospitals>
";

mysql_close($conn);
?>
</code>

When i run the page it gives an xml like so

<code>
<?xml version=“1.0”?>
<hospitals>
<name>Living Word Hospital</name>
<state><strong>Abia</strong></state>
<name>Obioma Hospital</name>
<state><strong>Abia</strong></state>
<name>Sancta Maria Specialist & Mat</name>
<state><strong>Abia</strong></state>
<name>Federal Medical Centre</name>

<state><strong>Adamawa</strong></state>
<name>Gal-Bose Hospital</name>
<state><strong>Adamawa</strong></state>
<name>Dammy Memorial Hospital</name>
<state><strong>Akwa-Ibom</strong></state>
<name>Samaritan Hospital</name>
<state><strong>Akwa-Ibom</strong></state>
<name>Harmony Specialist Hospital</name>
<state><strong>Anambra</strong></state>

<name>Kanayo Specialist Hosp. & Mate</name>
<state><strong>Anambra</strong></state>
<name>Federal Medical Centre</name>
<state><strong>Bauchi</strong></state>
<name>Niima Consultants Hospital</name>
<state><strong>Bauchi</strong></state>
<name>Borno Medical Clinic</name>
<state><strong>Benue</strong></state>

<name>Federal Medical Centre</name>
<state><strong>Benue</strong></state>
<name>Nakowa Specialist Hospital</name>
<state><strong>Benue</strong></state>
<name>St. Daniels Hospital</name>
<state><strong>Benue</strong></state>
<name>Zaman General Clinic</name>
<state><strong>Benue</strong></state>
<name>Canaan Medical Centre</name>

<state><strong>Cross River</strong></state>
<name>Mevon Hospital</name>
<state><strong>Cross River</strong></state>
<name>Lily Hospital</name>
<state><strong>Delta</strong></state>
<name>Nene Specialist Hospital</name>
<state><strong>Delta</strong></state>
<name>St.Rebecca’s Specialist Hospit</name>
<state><strong>Delta</strong></state>

<name>Ufor Hospital</name>
<state><strong>Delta</strong></state>
<name>West End Hosp. & Diagnostic Ce</name>
<state><strong>Delta</strong></state>
<name>Jon-Ken Hospital</name>
<state><strong></strong></state>
<name>Mount Sinnai</name>
<state><strong></strong></state>

<name>St. Nicholas Hospital</name>
<state><strong>*****</strong></state>
</hospitals>
</code>

And then when i run the above as2. It loads the xml bit does not display it.