# Doublespaced text loaded from PHP/MySQL

**URL:** https://forum.kirupa.com/t/doublespaced-text-loaded-from-php-mysql/105798
**Category:** Uncategorized
**Created:** [March 29, 2004, 11:39pm UTC](https://forum.kirupa.com/t/doublespaced-text-loaded-from-php-mysql/105798 "2004-03-29T23:39:07Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![pr0fess0r](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/pr0fess0r/32/480_2.png) [@pr0fess0r](https://forum.kirupa.com/u/pr0fess0r)
#### Post date: [March 29, 2004, 11:39pm UTC](https://forum.kirupa.com/t/doublespaced-text-loaded-from-php-mysql/105798/1 "2004-03-29T23:39:07Z")

</div>

(Sorry if this has been posted before)  
I have a problem that any text I load into a multiline componenet ends up double spaced…

I use this code in Flash:

var wtbData:LoadVars = new LoadVars();  
wtbData.onLoad = function(bSuccess:Boolean) {  
tArticle3.text = wtbData.result1;  
tArticle1.text = wtbData.result2;  
tArticle2.text = wtbData.result3;  
};  
wtbData.sendAndLoad(“[http://www.server.com/query.php](http://www.server.com/query.php)”, wtbData, “POST”);

to populate a mutliline text box with data.  
in PHP, the file is:

\<?php  
mysql\_connect(“host”,“login”,“pass”);  
mysql\_select\_db(“legavenue”);  
$result = mysql\_query(“select \* from wheretobuy”);  
if (mysql\_num\_rows($result)){  
while ($row = mysql\_fetch\_array($result)) {  
echo “&column1=”.urlencode($row[0])."&column2=".urlencode($row[1])."&column3=".urlencode($row[2]);  
}  
}  
echo “&”.rand()."&";  
?\>

The output I get if I just browse this directly is

&column1=Los+Angeles+Mart%0D%0A110+E.+9th+St.%2C+a-1053%0D%0ALos+Angeles%2C+CA

etc which is what I expect. But in Flash, all the text is doublespaced, and trace(this) outputs

&column1=Los%20Angeles%20Mart%0D%0A110%20E%2E%209th%20St%2E%2C%20a%2D1053%0D%0ALos%20Angeles%2C%20CA

how do I prevent all the doublespacing?

cheers