Mysql>php>xml>Flash?

1

Since I’ve been learning the ins and outs of basic php/mysql, I decided to check out this tut on outputting mysql to xml using php. This is so I can use dynamic content in flash, just not sure how to get it into flash.
So I have a test table set-up in my db and I have a file called mysql_php_xml.php with this script


<?php 

header("Content-type: text/xml"); 

$host = "localhost"; 
$user = "myusername"; 
$pass = "mypassword"; 
$database = "mydatabasename"; 

$linkID = mysql_connect($host, $user, $pass) or die("Could not connect to host."); 
mysql_select_db($database, $linkID) or die("Could not find database."); 

$query = "SELECT * FROM news_blog ORDER BY date DESC LIMIT 0, 5"; 
$resultID = mysql_query($query, $linkID) or die("Data not found."); 

$xml_output = "<?xml version=\"1.0\"?>
"; 
$xml_output .= "<entries>
"; 

for($x = 0 ; $x < mysql_num_rows($resultID) ; $x++){ 
    $row = mysql_fetch_assoc($resultID); 
    $xml_output .= "	<entry>
"; 
    $xml_output .= "		<date>" . $row['date'] . "</date>
"; 
        // Escaping illegal characters 
        $row['text'] = str_replace("&", "&", $row['text']); 
        $row['text'] = str_replace("<", "<", $row['text']); 
        $row['text'] = str_replace(">", "&gt;", $row['text']); 
        $row['text'] = str_replace("\"", "&quot;", $row['text']); 
    $xml_output .= "		<text>" . $row['text'] . "</text>
"; 
	$xml_output .=  "		<mood>" . $row['mood'] . "</mood>
"; 
    $xml_output .= "	</entry>
"; 
} 

$xml_output .= "</entries>"; 

echo $xml_output; 

?>

Then I have a basic flash file with 3 dynamic text fields with appropriate instance names. Heres the script in the fla


function  loadXML(loaded)  { 
if (loaded)  { 
_root.date  = this.firstChild.childNodes[0].childNodes[0].firstChild.nodeValue;
_root.text  = this.firstChild.childNodes[0].childNodes[1].firstChild.nodeValue;
date.text  = _root.date;
content_text.text  = _root.text;
}  else { 
  trace("file not loaded!");
}
}
 xmlData =  new XML();
xmlData.ignoreWhite  = true;
xmlData.onLoad  = loadXML;
xmlData.load("mysql_php_xml.php");

I basically just ripped it from another tut on displaying xml data in flash.
So I know it’s got to be wrong in some places.
When I test on my server I get nothing displaying in my swf.
The php file loads my db info just fine. My problem is getting the info from the php file to display in flash. I’m under the assumption that script outputs mysql data into xml via php. Am I going about this the right way?
Any help in the right direction? :beer: