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

**URL:** <https://forum.kirupa.com/t/help-with-loading-xml-data-embeded-in-php-in-flash-list-component/286210>\
**Category:** flash\
**Created:** [April 11, 2009, 10:46pm UTC](https://forum.kirupa.com/t/help-with-loading-xml-data-embeded-in-php-in-flash-list-component/286210 "2009-04-11T22:46:27Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![southpawnigeria](https://avatars.discourse-cdn.com/v4/letter/s/91b2a8/32.png) [@southpawnigeria](https://forum.kirupa.com/u/southpawnigeria)\
**Post date:** [April 11, 2009, 10:46pm UTC](https://forum.kirupa.com/t/help-with-loading-xml-data-embeded-in-php-in-flash-list-component/286210/1 "2009-04-11T22:46:27Z")

</div>

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.