Php/rss into flash text field

1

I have the following php code that creates an rss page dynamically when called.

<?php
header('Content-type: text/xml');
echo '<?xml version="1.0" encoding="UTF-8"?>';
// Set RSS version.
echo '
<rss version="2.0"> ';
// Start the XML.
echo '
<channel>
<title>?????</title>
<description>????????</description>
<link>??????</link>';
// Create a connection to your database.
	  require_once ('theConnectionlocation.php'); // Connect to the db.
// Query database and select
$data = mysql_query('SELECT * FROM ??? ORDER BY id DESC');

while($row = mysql_fetch_array($data))
{
echo '
<item>
<title>'.$row['heading'].'</title>
<pubdate>'.$row['date'].'</pubdate>
<description><![CDATA['.$row['news'].']]></description>
<link>'.$row['link'].'</link>
</item>';
}
echo '
</channel>
</rss>';

?>

I would like to display all the information within a textbox within flash to basically create a dynamically scrolling text box when loaded.

Now can the above be used or a simple piece of php to read the db and the info I want??

But my question is how would i read the info into the textbox in flash (AS2) to list as follows:

heading, date, news and link.

and list all in the db or a total that I specify in my php.

I can use the easy php to access the db to get the info if the above is complicated:

<?php
// Create a connection to your database. */
	  require_once ('connectotdb.php'); // Connect to the db.
// Query database and select the last 10 entries.
$data = mysql_query('SELECT * FROM ????? ORDER BY id DESC');

while($row = mysql_fetch_array($data))
{
echo '<br /><br ><b>'.$row['heading'].'</b><br >'.$row['date'].'<br />'.$row['news'];
}

?>

where i have the echo code:

echo '<br /><br ><b>'.$row['heading'].'</b><br >'.$row['date'].'<br />'.$row['news'];

It would be good to get this displayed into the textbox.
anyway will stop the chatter, many thanks

me