Xml parsing problems... big big problems :(

I am having a problem parsing xml data, I know how to get it into as3, and that is working pretty well after following a brilliant tutorial on kirupa: http://www.kirupa.com/developer/flashcs3/using_xml_as3_pg1.htm

But I am having a problem tracing the data that I want. Seemingly it is connecting to the database and is working in that sense but when I try to trace data I am getting a couple problems.

The first is that I need to somehow specify a value of a single item to get the rest of the data. Here is the xml:

XML Code

$query2 = “select * from circle where owner={$line[“id”]};”;
$result2 = mysql_query($query2) or die("Query failed2 : " . mysql_error());
while ($line2 = mysql_fetch_array($result2, MYSQL_ASSOC))

print "



print “</user>”;

Now it seems that I need to input an ID for the user to be able to trace their circles/information so I tried using this as3 code to do this:

AS3 Code
var xmlLoader:URLLoader = new URLLoader();
var xmlData:XML = new XML();

xmlLoader.addEventListener(Event.COMPLETE, LoadXML);
xmlLoader.load(new URLRequest(“http://www.chaudiovisual.com/testing/show-user.php”));

function LoadXML(e:Event):void
xmlData = new XML(e.target.data);

function Parse(parse:XML):void
trace(“XML Output”);
var userList:XMLList = parse.user;
for each (var userElement:XML in userList)
if (userElement.text() == 1)

Can anyone help me out here?

Thanks in advance,