# Flash XML PHP - Undefined

**URL:** <https://forum.kirupa.com/t/flash-xml-php-undefined/274936>\
**Category:** flash\
**Created:** [November 6, 2008, 5:44pm UTC](https://forum.kirupa.com/t/flash-xml-php-undefined/274936 "2008-11-06T17:44:59Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![agaisab](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@agaisab](https://forum.kirupa.com/u/agaisab)\
**Post date:** [November 6, 2008, 5:44pm UTC](https://forum.kirupa.com/t/flash-xml-php-undefined/274936/1 "2008-11-06T17:44:59Z")

</div>

I am having troubles loading xml data (via php/mysql) into an animated swf. The first time it loads it works, but everytime i run the animation the result is “undefined”. I am attempting to load a registered user’s first name from mysql through php. I am defining this data by $\_SESSION[‘username’] in the php, which the creates the xml. Any hints on this matter would be greatly appreciated.

PHP:  
\<?php  
session\_start();  
$link = mysql\_connect(“XXXXXXX”, “XXXXXXX”, “XXXXXXX”);  
mysql\_select\_db(“XXXXXXX”);  
$query = “SELECT \* FROM users WHERE username = '”. $\_SESSION[‘username’] ."’";  
$results = mysql\_query($query);  
echo "\<?xml version=“1.0” encoding=“ISO-8959-1”?\>  
";  
echo "\<FirstNames\>  
";  
while($line = mysql\_fetch\_assoc($results)) {  
echo “\<item\>” . $line[“FirstName”] . "\</item\>  
";  
}  
echo "\</FirstNames\>  
";  
?\>

Flash AS:  
my\_xml = new XML();  
my\_xml.load(“[http://www.XXXXXX.php?nocache=](http://www.XXXXXX.php?nocache=)” + Math.random());  
my\_xml.onLoad = my\_function;  
my\_xml.ignoreWhite = true;  
function my\_function() {  
dynamictextbox\_instancename = my\_xml.firstChild.childNodes[0].firstChild.nodeValue;  
}

Thanks again!  
Mike