# MySQL-php-xml-flash : Can't render htmlText!

**URL:** <https://forum.kirupa.com/t/mysql-php-xml-flash-cant-render-htmltext/179472>\
**Category:** programming\
**Created:** [February 20, 2006, 3:21pm UTC](https://forum.kirupa.com/t/mysql-php-xml-flash-cant-render-htmltext/179472 "2006-02-20T15:21:37Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![joakimlinden](https://avatars.discourse-cdn.com/v4/letter/j/51bf81/32.png) [@joakimlinden](https://forum.kirupa.com/u/joakimlinden)\
**Post date:** [February 20, 2006, 3:21pm UTC](https://forum.kirupa.com/t/mysql-php-xml-flash-cant-render-htmltext/179472/1 "2006-02-20T15:21:37Z")

</div>

My problem is a bit complicated to explain… I’ll try anyway.

I’m using a php script to convert data from a mysql db into xml, here’s part of it:

```php
echo "<?xml version=\"1.0\"?>
";
echo "<splash>
";
// CDATA allows htmlformated text...
while($line = mysql_fetch_assoc($results)){
    echo "<currItem>
";
    echo "<htmltxt>
<![CDATA[" . $line["htmltxt"] . "]]>
</htmltxt>
";
    echo "<imgpath>
<![CDATA[" . $line["imgpath"] . "]]>
</imgpath>
";
    echo "<imgpaththumb>
<![CDATA[" . $line["imgpaththumb"] . "]]>
</imgpaththumb>
";
    echo "</currItem>
";
}
echo "</splash>
";

```

When you load this php file you’ll get a working XML:

```auto
<splash>
<currItem>
<htmltxt>
<i>Italic text</i> blablabla... <br />New line....<br />My name is <b>blabla</b>...
</htmltxt>
<imgpath>
images/image01.jpg
</imgpath>
<imgpaththumb>
thumbs/thumb01.jpg
</imgpaththumb>
</currItem>
</splash>

```

So… As you can see, the html-tags are there. But when I load this into flash I get this in the TRACE window:

> \<i\>Italic text\</i\> blablabla… \<br /\>New line…\<br /\>My name is \<b\>blabla\</b\>…

And this in the flash movie htmlTextfield:

> \<i\>Italic text\</i\> blablabla… \<br /\>New line…\<br /\>My name is \<b\>blabla\</b\>…

I can’t figure out where it goes wrong, but my guess is Flash.

Anybody who have had to deal with this and solved it?