pass large amount of text?

[bobby_rahman]

Hiya,

I have a field in db that is a description entered by user of a bug. Clearly this may be quite long.

Now when I show all these bugs in main.php I made every bugid a link to a view_bug_page, which will show the description of that bugid. Such a large amount of data when shown in view_bug_page the text is just one long line as this is how it is inserted into mysql. This causes problems when it expands the table to the length of the text.

So what is the best way to solve this:

Is there a way to wrap the text in MySQL directly before you put it in. So when it is retrieved I do not have to do any php functions on it -just simple display in a row.

The problem is that I dont think I can wordwrap() the description text before inserting the text into view_bug_page as it is not defined in main_page.php as this is only the summary screen.

At the moment I get fom the main_page.php(Summary) to view_bug_php(detailed-displaying description) using

<a href=\"view_bug.php?var1=$row[bugid]&date=$row[date_opened]&estdate=$row[estimated_completion]\">
" . $row['bugid'] . "</a></font></td>

So anyone with any help would be v.appreciated

Cheers

Bobster

[autumn]

when outputting your text, you gotta replace all your line breaks (\n or \r on win) with an HTML <BR>.

say your text is $body, before echoing it do this:

$body = nl2br($body);

that's 'new line to <BR>'.

A