I am trying to load text from a string in a PHP file to a dynamic text field in Flash. I have the dynamic field set so it can accept html tags, but for some reason it is outputing the “<p>” and </p> tags in the text field. The PHP file compiles a string from 20 forms and puts it into one, so I need each of the 20 forms to be a new paragraph. Take a look at my code and tell me what you think. Thanks for any help.
<?php
//mysql_connect("servername","username","password");
//mysql_select_db("dbname");
$databaseID = mysql_connect("localhost", "root", "ui0p0iu") or die("Failed to connect to localhost");
$result = mysql_select_db("drreed") or die ("Failed to connect");
$listings = "SELECT * FROM content";
$get_listings = mysql_query($listings) or die ("get listings query failed");
$counter = 0;
$actualCounter = 0;
while ($row4=mysql_fetch_array($get_listings))
{
$counter++;
if ($counter == 1)
$printCounter = "";
else
$printCounter = $counter;
$temp = "p".$counter;
if ($row4[$temp] != "")
{
$actualCounter++;
echo '&my_title'.$printCounter.'=<p>'.$row4['title']. '</p>';
echo '&my_date'.$printCounter.'=<p>'.$row4['date']. '</p>';
echo '&my_article'.$printCounter.'=<p>'.$row4['title'].'</p>';
for($x = 1; $x <= 20 ; $x++)
{
$temp2='p'.$x;
if ($row4[$temp2] != '')
echo '<p>'.$row4[$temp2].'</p>';
}
}
}
$rString = "&num=".$actualCounter."&";
echo $rString;
?>
Here’s the AS of the frame:
[left]myData = new LoadVars();
myData.load("admin/data.php", my_lv, "POST");
myData.onLoad = function(success)
{
if(success)
{
_root.article.textbox_article.text = this.my_article;
}
}
stop();
[/left]
[left]And the AS of the movie that the dynamic textbox is in:[/left]
[left]
[left][left]onClipEvent (load){
myData = new LoadVars();
myData.load("admin/data.php", my_lv, "POST");
myData.onLoad = function(success)
{
if(success)
{
_root.article.textbox_article.text = this.my_article;
}
}
[left][/left]
scrolling = 0;
frameCounter = 1;
speedFactor = 3;
}
onClipEvent (enterFrame){
if( frameCounter % speedFactor == 0){
if( scrolling == "up" && textbox_article.scroll > 1){
textbox_article.scroll--;
}
else if( scrolling == "down" && textbox_article.scroll < textbox_article.maxscroll){
textbox_article.scroll++;
}
frameCounter = 0;
}
frameCounter++;
}
[left][/left]
stop();
[/left]
[/left]
[/left]
