Little help with XML with flash.

[PokeTech]

Well I'm fairly new at XML but I've read a few tutorials and watching a few videos but I can't seem to figure out how to do this, thats why I'm asking for help...

Ok Well I have this PHP file which is getting information from mysql database and turning it into XML:

***********
<?php
$link = mysql_connect("localhost","db","password");
mysql_select_db("db");
$query = 'SELECT * FROM table';
$result = mysql_query($query);
echo "<?xml version=\"1.0\"?>\n";
echo "<users>\n";
while($line = mysql_fetch_assoc($result)) {
echo "<user>" . $line["username"] . "</user>\n";
}
echo "</users>\n";
mysql_close($link);
?>
***********

And then I want to get that into the flash program so that I can display the username's. Well I'm using SWiSHmax to make my flash stuff and after turning the stuff into XML I don't really know where to go after that. So does anybody know where there's a tutorial or maybe you could help me.

Thanks in advance!

[eelixduppy]

Have you tried a G search [google.com] with those specific keywords? Take a look, you'll find everything you'll need to work with XML in your flash apps.

[rocknbil]

Have your PHP actually write the XML to a file and use the tools to load XML, or nest a getURL that gets the PHP script inside loading the XML.