flash text rotator xml

Ok so hereby I am starting a new topic after successful coding of xml file - Thanks to Jodes and others who have helped me with the solution. Now to the interesting part.

I am trying to produce flash text rotators from the xml file.Now i could do this in javascript which I have already implemented see link:dedication message

I want to display text instead of the image similarly like :jw image rotator

Below is the code from recently added xml:`

$DB_SERVER = "localhost"; $DB_NAME = "yourdatabasename"; $DB_USER = "yourdbuser"; $DB_PASSWORD = "yourpw";

mysql_connect($DB_SERVER, $DB_USER, $DB_PASSWORD);

$sql = "select * from songlist order by date_added desc limit 10";

$res = mysql_query($sql);

while ($result = mysql_fetch_assoc($res)){ ?> ]]> `

To ca开发者_如何学编程ll the xml file in html :`

<title>text Rotator</title>

<style type="text/css">
    body { background-color: #fff; padding: 0 25px; color:#000; font: 13px/18px Arial, sans-serif; }
    a { color: #360; }
    h3 { padding-top: 50px; }
    ol { margin:5px 0 15px 16px; padding:0; list-style-type:square; }
</style>

<div id="container"><a href="http://www.macromedia.com/go/getflashplayer">Get the Flash Player</a> to see this rotator.</div>
<script type="text/javascript" src="swfobject.js"></script>
<script type="text/javascript">
    var s1 = new SWFObject("textrotator.swf","rotator","400","200","7");
    s1.addParam("allowfullscreen","false");
    s1.addVariable("file","**recently added.xml**");
    s1.addVariable("width","400");
    s1.addVariable("height","200");
    s1.write("container");
</script>

`

Overall I am having the following files: recently added.xml,recnetly added.html & recently added.swf Please let me know if there is too much involved or guide if there is any flash based text rotator which can extract information from the database and display many thanks and sorry for the big question!!!

---

In my opinion your question is quite confusing. If i'm guessing right, you want:

A html page, containing a flash, which loads dynamic text, extracted as xml from a mysql database with the help of php?

If so you should have:

1x html file, which loads the swf.

1x flash file, which loads texts and rotates them.

1x php (or asp perhaps) file, which generates xml from the database and serves the flash.