PHP - How to echo into one textarea tag ? Plz HeLp!!!

[nster]

Hello guys,
am trying to make a simple shout~box with PHP ,
but i have stuck somehow ..)
am trying to make the echo to be written into a <textarea></textarea> tag , but is impossible cause when finally outputs on screen is printed there more than 1 diferent <textarea>..

Look the here :

PHP Code:

mysql_connect($lololo,$lala,$lalala) or die(mysql_error());

    mysql_select_db($ololol) or die(mysql_error());

    $query = "SELECT msg1, theauthor, thetime, thedate, thehost 
FROM shoutbox order by id DESC LIMIT 8";
    $result = mysql_query($query);
    echo "<table>";
    while ($r=mysql_fetch_array($result))  
  
    { 

        echo "<textarea><tr><td><font size='2'>
By $r[date] by <a href='mailto:$r[thetime]'>
$r[theauthor]</a></font></td></tr>
<tr><td><font size='2'>$r[msg1]</font></td></tr>
<tr><td><hr></td></tr></textarea>";
        
 }
    echo "</table>";
?> 


the result of this, will be more than 1 textarea boxes on my page.. how to correct this, so that every of thy echos that will ever be will be written into one textarea box ?

Thanks in advances fellas n' dudes
waiting for your help on it

[nster]

ops (!)
i made some progress here..
i remove all tags into textarea tag and i set textarea in diferent place so now works at least the text is written into 1 textarea .

Have a look plz,

PHP Code:

      ..//connect to db etc
  
   
      $query = "SELECT msgg, author, city, date, iphost
   
      FROM shoutbox order by id DESC LIMIT 9";
   
          $result = mysql_query($query);
   
          echo "<textarea rows=10 cols=20>";
   
          while($r=mysql_fetch_array($result))   
   
          {
  
              echo "
  
      posted at-by $r[date] by <A HREF='mailto:$r[city]'>
  
      $r[author]
 
 $r[mesgg]";
  
             
          }

echo "</textarea>"; 


The only problem now is, the <A HREF='mailto:$r[city]'> !! <-- this tag of link .

I want to be visible a link at that place.. but is imposible to show a link there into the textarea now like this..cause if you try it the tag of href will be written there...

How to fix this , so that there into our textarea tag will work fine the a href link tang too so that will be visible a link there ??

Someone told me by replacement.. but how we can do replecment i havent done that before ..please show me how to

Thanks again waiting for your help...

[brealmz]

htmlentities("<A HREF='mailto:$r[city]'>");

[Izzmo]

Okay, I don't know if this has been solved yet, but.. you need to do this in your echo tag:

PHP Code:

 echo "
  
      posted at-by ".$r[date]." by <A HREF='mailto:".$r[city]."'>
  
      ".$r[author]."
 
 $r[mesgg]; 


If you are trying to display an array variable, you need to get it out of the quotes of echo first, thus doing ".$variable[xxx]."

[brealmz]

.. sorry about that..

you can do also
htmlentities("<A HREF='mailto:{$r[city]}'>");

[nster]

thanks so much guys (Izzmo, brealmz)