[RESOLVED] Display table data in textarea

[roscor]

Hi,

I have a database which displays data into a table which is viewed by members. What I am after is displaying the data in a textarea so that members can scroll down as there may be mutiple records.

here is my table which displays the data. Will I have to alter how I have set the structure of the table.?

  <table border="0" width="800" height="50"  style="border-collapse: collapse" bordercolor="#111111">


<tr>

  <td width="100%" height="50" valign="top"  style="border-collapse: collapse" bordercolor="#111111">



</div>
<table border="1" cellspacing="2" cellpadding="4" align="center" style="border-collapse: collapse" bordercolor="#111111" bgcolor="#9395EC">
<tr><align="center" >
<th><font face="Arial, Helvetica, sans-serif" ><a href="" title="County">County</font></a></th>
<th><font face="Arial, Helvetica, sans-serif"><a href="" title="Left">Left</font></a></th>
<th><font face="Arial, Helvetica, sans-serif"><a href="" title="Property">Property</font></a></th>
<th><font face="Arial, Helvetica, sans-serif"><a href="" title="looked">Look</font></a></th>
<th><font face="Arial, Helvetica, sans-serif"><a href="" title="Damaged">Dam</font></a></th>
<th><font face="Arial, Helvetica, sans-serif"><a href="" title="Complaints">Comp</font></a></th>
<th><font face="Arial, Helvetica, sans-serif"><a href="" title="Difficulty">Diff</font></a></th>
<th><font face="Arial, Helvetica, sans-serif"><a href="" title="Evicted">Evic</font></a></th>
<th><font face="Arial, Helvetica, sans-serif"><a href="" title="Would">Would</font></a></th>
<th><font face="Arial, Helvetica, sans-serif"><a href="" title="Date Record Submitted">Date Sub</font></a></th>
<th><font face="Arial, Helvetica, sans-serif"><a href="" title="ID">LL ID</font></a></th>
<th><font face="Arial, Helvetica, sans-serif"><a href="" title="Overall Percentage">%</font></a></th>

</tr>

<?
$i=0;
while ($i < $num) {

$county=mysql_result($result,$i,"county");
$left=mysql_result($result,$i,"left");       

$rent=mysql_result($result,$i,"rent");
$look=mysql_result($result,$i,"look");
$dam=mysql_result($result,$i,"dam");
$comp=mysql_result($result,$i,"com");
$diff=mysql_result($result,$i,"diff");
$evic=mysql_result($result,$i,"evic");
$would=mysql_result($result,$i,"would");
$date=mysql_result($result,$i,"datesubmitted");
$landlordloid=mysql_result($result,$i,"landid");
?>

<tr>
<form action="result.php" method="get">
<th><input type="hidden" size="20%" value="<? echo $county; ?>" name="county">&nbsp;<? echo $county; ?>&nbsp;</th>
<th><input type="hidden" size="25%" value="<? echo $left; ?>" name="leftongoodterms"><? echo $left; ?><?
    if ($left == "Yes"){

       echo "<font color = #00FF00 >$pos1</font>";
       $pos1 = '12.5';
 } 
      else {                         

           echo "<font color = #FF0000>$neg1</font>";
           $pos1 = '0';
       }


?></th>
<th><input type="hidden" size="25%" value="<? echo $rent; ?>" name="rent"><? echo $rent; ?><?
    if($rent == "No"){

        echo "<font color = #00FF00 >$pos2</font>";
        $pos2 = '12.5';
 } 
      else {
            echo "<font color = #FF0000>$neg2</font>";
            $pos2 = '0';
       }


?></th>
<th><input type="hidden" size="25%" value="<? echo $look; ?>" name="look"><? echo $look; ?><?
    if ($left == "Yes"){

       echo "<font color = #00FF00 >$pos3</font>";
       $pos3 = '12.5';
 } 
      else {                         

           echo "<font color = #FF0000>$neg3</font>";
           $pos3 = '0';
       }


?></th>
<th><input type="hidden" size="25%" value="<? echo $dam; ?>" name="dam"><? echo $dam; ?><?
    if($dam == "No"){
           echo "<font color = #00FF00 >$pos4</font>";
           $pos4 ='12.5';
 } 
      else {              

           echo "<font color = #FF0000>$neg4</font>";
           $pos4 = '0';
       }


?></th>
<th><input type="hidden" size="25%" value="<? echo $comp; ?>" name="com"><? echo $comp; ?><?
    if($comp == "No"){
            echo "<font color = #00FF00 >$pos5</font>";
            $pos5 = '12.5';
 } 
      else {              

            echo "<font color = #FF0000>$neg5</font>";
            $pos5 = '0';
       }


?>   </th>
<th><input type="hidden" size="25%" value="<? echo $diff; ?>" name="diff"><? echo $diff; ?><?
    if($diff == "No"){
            echo "<font color = #00FF00 >$pos6</font>";
            $pos6 = '12.5';
 } 
      else {              

             echo "<font color = #FF0000>$neg6</font>";
             $pos6 ='0';
       }


?></th>
<th><input type="hidden" size="25%" value="<? echo $evic; ?>" name="evic"><? echo $evic; ?><?
    if($evic == "No"){
           echo "<font color = #00FF00 >$pos7</font>";
           $pos7 = '12.5';
 } 
      else {              

            echo "<font color = #FF0000>$neg7</font>";
            $pos7 = '0';
       }



?>   </th>
<th><input type="hidden" size="25%" value="<? echo $would; ?>" name="would"><? echo $would; ?><?
    if($would == "Yes"){

        echo "<font color = #00FF00 >$pos8</font>";
        $pos8 = '12.5';
 } 
      else {   

        echo "<font color = #FF0000>$neg8</font>";
        $pos8 = '0';
   }




 if ($total !=1) {

     $percentage =$pos8+$pos7+$pos6+$pos5+$pos4+$pos3+$pos2+$pos1; 
}
    else {






   }

$pos1 ="+";
$neg1 ="-";
$pos2 ="+";
$neg2 ="-";
$pos3 ="+";
$neg3 ="-";
$pos4 ="+";
$neg4 ="-";
$pos5 ="+";
$neg5 ="-";
$pos6 ="+";
$neg6 ="-";
$pos7 ="+";
$neg7 ="-";
$pos8 ="+";
$neg8 ="-";


?>
</th>
<th><input type="hidden" size="20%" value="<? echo $date; ?>" name="datesubmitted"><? echo $date; ?></th>
<th><input type="hidden" size="20%" value="<? echo $landid; ?>" name="landid"><? echo $landid; ?></th>
<th><input type="hidden" size="20%" value="<? echo $percentage; ?>" name="percentage">&nbsp;<?
if ($percentage >= 87.5) {
    $color = '#00FF00';
} elseif ($percentage >= 37.5) {
    $color = '#ff9900';
} else {
    $color = 'red';
}
echo '<b style="color:' . $color . '">' . $percentage . '</b>';
  ?>&nbsp;</th>
</form>


</tr>

<?
$i++;
}


echo "</table>";




?>



</table>

Hope someone can help,

thanks roscor

[Rodney_H_]

EDIT: Maybe I misunderstood you.

All you need to do, if you really want to output into a textarea is just that. Echo or print the values into the form element, making sure to use htmlspecialchars() so a quotation mark won't stop the output inadvertently...

(original reply follows)

No. You don't mean a textarea, which is a form element.

What you want is a scrollable DIV element in your markup.

OR, an iFrame, but I recommend the scrollable DIV as the better of these two options.

(Perhaps someone else will advise something else...)

To create scrollable divs you would do something like this:

<div class="scrollable" style="height:250px; width:100%; overflow:auto;">
<!-- your data would go IN HERE ... //-->
blah, dee, blah, blah, blah... (etc...)
</div>

You can use an external style-sheet and put the attributes there, but the general idea is to set a HEIGHT of X number of pixels and another attribute of "overflow: auto;"

By setting this second attribute you are saying, if the content grows beyond the HEIGHT (or width) to use SCROLLBARS..

Hope that helps.

(As a sidenote, the font tag has been deprecated. You should use an external style sheet and classes, or, at the very least, use inline styles...)

[roscor]

Many thanks Rodney H.

That is exactly what I meant, Tried and it works brill,

Cheers roscor