Can't display MediumText carriage returns using PHP

mmoranuk

I'm trying to display a mediumtext field from a mysql database and it doesn't include return characters, ie, just comes out as a long string. I want to be able to display the text as it is entered in the database (ie, with the carriage returns in the right place).

The code snippet is:

$i =0;
	while ($i <$num_change_requests):
	$cr_title = mysql_result($result,$i,"cr_title");
	$cr_text = mysql_result($result,$i,"cr_text");

echo "
<td width=\"30%\"><div align=\"center\">$cr_title</div></td>
<td width=\"70%\"><div align=\"center\">$cr_text</div></td>
     ";
$i++ ;
endwhile;

The cr_text field is the mediumtext. The output is obviously in a table.

Any ideas would be great. Thanks, M.

Norman_Graham

Hi Moranuk

You want this function.

HTH

Norm

mmoranuk

Bingo - that works - thanks for the help. M

mmoranuk

Norm - or anyone else

This works to a point but introduces a new issue. I have nl2br() wrapped around the echo but the output appears to have a new line break for each time the function is executed. This mean that if the loop runs once, the table is printed out just below the title, but if the loop runs 2 or more times, the whole lot is moved down a line per loop.

So in my example I have 10 rows of data to print out, the table starts off the bottom of the page. I can't see a way to prevent this but it is making it unusable.

I have tried the function in every conceivable place. Any ideas? Thanks in advance, Mark.