Hey there users. I’ll explain what Im trying to acheieve here.
In my MySQL database, I have some news in the database and I wanted to display them in flash. In my PHP page its going to loop so it will do this for example
March 24, 2004
I did this and I did that
January 25, 2003
I did this and I did whatever
July 2002
What is the matter man!
So what Im trying to do is display those news in my flash but Im having some problems… Here is my line of code
Test.php:
<?php require_once(‘Connections/test.php’); ?>
<?php
mysql_select_db($database_test, $test);
$query_test = “SELECT * FROM test”;
$test = mysql_query($query_test, $test) or die(mysql_error());
$row_test = mysql_fetch_assoc($test);
$totalRows_test = mysql_num_rows($test);
?>
<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>
<html xmlns=“http://www.w3.org/1999/xhtml”>
<head>
<title>Untitled Document</title>
<meta http-equiv=“Content-Type” content=“text/html; charset=iso-8859-1” />
</head>
<body>
<?php do { ?>
<?php echo “&message=$row_test[subject]”; ?>
<?php } while ($row_test = mysql_fetch_assoc($test)); ?>
</body>
</html>
<?php
mysql_free_result($test);
?>
But I do know how to display just one line of text in flash by doing this
news.php:
<?
echo “&message= This is just a news flash. I need some help with your suggestions sir. Please call me back”;
?>
News.swf: actionscript
Already made a dynamic text area and gave the instance name “message” and converted it into movie clip.
onClipEvent (load) {
//assuming you have a personal web server and PHP installed locally
loadVariables(“http://localhost/PHP_MySQL_Flash_Test/news.php”, this, “GET”);
}
And it will then display this in the flash: This is just a news flash. I need some help with your suggestions sir. Please call me back
But Im having problems when I try to loop the information. Please reply back
