[RESOLVED] Multiple Results + Single Variable

[obrienkev]

Hi all,

My query below returns multiple rows. How do I get the results from each row returned to display in below textarea?

Thanks.

$query_cmt = "SELECT * ".
			 	     "FROM comments_log ".
				     "WHERE fund_ID = '$id'";
$result_cmt = mssql_query($query_cmt) or die('Select Query_CMT Error');
while($row_cmt = mssql_fetch_array($result_cmt))
{
 					$comment_log = $row_cmt['comments'];
					$comment_date = $row_cmt['comments_date'];
}

I want to display all rows returned below...

<textarea name="comments_log" id="comments_log" rows="8" cols="30">
<?php echo $comment_log.' '.$comment_date ?>
</textarea>

[saraadmin]

Do you mean that you want one <textarea> for each row?

$query_cmt = "SELECT * FROM comments_log WHERE fund_ID = '$id'";
$result_cmt = mssql_query($query_cmt) or die('Select Query_CMT Error');

while($row_cmt = mssql_fetch_array($result_cmt))
{
  $comment_log = $row_cmt['comments'];
  $comment_date = $row_cmt['comments_date'];
?>
<textarea name="comments_log" id="comments_log" rows="8" cols="30">
<?= $comment_log.' '.$comment_date ?>
</textarea> 
<?
}

Or all the rows in one <textarea>

<?php ?>
<textarea name="comments_log" id="comments_log" rows="8" cols="30">
<?
$query_cmt = "SELECT * FROM comments_log WHERE fund_ID = '$id'";
$result_cmt = mssql_query($query_cmt) or die('Select Query_CMT Error');
while($row_cmt = mssql_fetch_array($result_cmt))
{
  $comment_log = $row_cmt['comments'];
  $comment_date = $row_cmt['comments_date'];
  echo ($comment_log . " " . $comment_date . "\n");
}
?>
</textarea>

[obrienkev]

That's it. Thanks!!