So far, I've managed to bring an entry into Flash from MySQL via PHP. here: http://www.andrewknapp.com/temp/flashnews/flashnews.swf

It is showing only one entry. Could anyone tell me how I would reformat what I have to make it alternate, in the same window, between Date and Message? Just like anyother news format. Here is the code I have thus far:

PHP:
Code:
<?

include("common.php");

    mysql_connect($db_host,$db_user,$db_password) or die(mysql_error());

    mysql_select_db($db_name) or die(mysql_error());

	$query = "SELECT * FROM tempernews ORDER BY id ASC";
	
	$result = mysql_query($query) or die ("Error");
	
	$num_rows = mysql_num_rows($result);
	
	for($i=0;$i<$num_rows;$i++){
	
		$row = mysql_fetch_array($result);
				
		$news = "news$i";
		$news = $row['message'];
		
		$date = "date$i";
		$date = $row['date'];
		
		print("&news$i=$news");
		print("&date$i=$date");
		
	}
	
?>
FLASH:
Code:
System.useCodepage = true;
format = new TextFormat();
testo.html = true;
function formatText(textBox, ita, siz, Bold, colour) {
    format.italic = ita;
    format.size = siz;
    format.bold = Bold;
    format.font = "Arial";
    format.align = "left";
    format.color = colour;
    textBox.setTextFormat(format);
}
testo.text = "Loading news...";
formatText(testo, true, 10, true);
date.text = "Loading...";
formatText(date, true, 10, true, "0xFF0000");
temp = new LoadVars();
temp.load("flashnews.php");
temp.onLoad = function() {
    myArray = new Array();
    for (var a in this) {
        if (a != "onLoad") {
            myArray.push(this[a]);
        }
    }
    date.text = myArray[0];
    formatText(date, false, 10, true, "0xFF0000");
    testo.htmlText = myArray[1];
    formatText(testo, true, 10, true);
    var oldt = getTimer();
    var ok = true;
    var l = myArray.length;
    var i = 5;
};
Here's the Fla: http://www.andrewknapp.com/flashnews/flashnews.zip