How to get tinytext value outputed to multi line HTML instead of single string???

[ariliquin]

I have a field in a table which is type tinytext. It has three distinct lines of text. When I pass it to results and the mysql_fetch_object object it becomes a string. How do I access the value keeping the line returns or whatever code MySQL stores to determine end of line and then pass each line one at a time so I can format the page as such? Any help would be greatly appreciated. Thanks.

[TobyRT]

Try

$tinytext = $_GET($row ['tinytext']);
echo '<textarea name = "tinytext">'.nl2br($tinytext).'</textarea>';

The nl2br() should put the linebreaks back in.

[ariliquin]

when I run this I get the following error:

Fatal error: Call to undefined function: array() in /scripts/tinytext.php on line 35

Code on line 35 is as suggested:

$tinytext = $_GET($row["Contact_Details"]);

This following line works fine and returns data to the browser:

echo nl2br($row["Contact_Details"]);

Thanks TobyRT nl2br has solved the problem and was exactly what I was looking for. Cheers.

[TobyRT]

I was wondering if that string was correct, but as long as the nl2br() works, don't worry about it!