# Couldn't show "&" from SQL\> PHP\> FLASH

**URL:** <https://forum.kirupa.com/t/couldnt-show-from-sql-php-flash/291821>\
**Category:** Uncategorized\
**Created:** [July 6, 2009, 11:50am UTC](https://forum.kirupa.com/t/couldnt-show-from-sql-php-flash/291821 "2009-07-06T11:50:47Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Zen\_Nam](https://avatars.discourse-cdn.com/v4/letter/z/9fc29f/32.png) [@Zen\_Nam](https://forum.kirupa.com/u/Zen_Nam)\
**Post date:** [July 6, 2009, 11:50am UTC](https://forum.kirupa.com/t/couldnt-show-from-sql-php-flash/291821/1 "2009-07-06T11:50:47Z")

</div>

Dear all,

I’m doing a flash site with some data in MySQL, I have create a text field on flash and set the html = true, but it can not show the “&” no matter I type & or & on my data base… how can I show the & sign?

What I have done on MySQL is - type “me & you” on a field called “designer” which under an item call “table”.

Then my PHP output will be:  
&n=4&&id0=2&&prod\_name0=table&designer0=me & you&wholesales\_price0=&price0=1,680…

and my AS on flash is :

this.createTextField(“my\_txt”, 10, 100, 100, 100, 19);  
my\_txt.autoSize = “left”;  
my\_txt.html = true;  
get\_full\_desc ();

function get\_full\_desc () {  
var get\_item = new LoadVars();  
get\_item.load (“productbycat.php?sid=”+ 7);  
get\_item.onLoad = function(success){  
if (success){  
my\_txt.htmlText = this[“designer”+0];  
}  
}  
}

BUT, the out come of the flash just show “me” on designer, the words “& you” were unable to show, can any one knows the solution?

thx,  
Zen Nam