Welcome to WebmasterWorld Guest from 54.198.185.204

Forum Moderators: open

Message Too Old, No Replies

Little help with XML with flash.

     
11:01 pm on Jul 26, 2008 (gmt 0)

Junior Member

5+ Year Member

joined:Feb 2, 2008
posts:99
votes: 0


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!

3:55 am on July 29, 2008 (gmt 0)

Senior Member

WebmasterWorld Senior Member eelixduppy is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Nov 12, 2005
posts:5966
votes: 0


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.
4:05 pm on July 31, 2008 (gmt 0)

Senior Member

WebmasterWorld Senior Member rocknbil is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Nov 28, 2004
posts:7999
votes: 0


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.