Pulling text from DB problem

Arc

Hi. I am entering text into the DB from a textarea field that has 25 cols. This means it adds a linebreak every 25 characters(i think). So i am entering the text into the DB and it looks like this.

ZZZZZZZZZZZZZZZZZZZ
ZZZZZZZZZZZZZZZZZZZ
ZZZZZZZZZZZZZZZZZZZ
ZZZZZZ

Now i am pulling the text out of the DB and displaying it in a table. Like this

If ($ResultArray [4] != ""){
  Print "<tr>";
  Print "<td width = 325><font color=\"#FF0000\"><b>".nl2br($ResultArray [4])."</font></b></td>";
  Print "</tr>";
}

Now the problem is the text comes out as one really long line and stretches the table out instead of staying within the table and using wordwrap. example:
ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ

So how can i confine this text to the borders of the table and not let it stretch out the table?

Thanks!😃

sarahk

I'd say that your text area has word wrapping and unless the user presses enter there won't be any new lines to convert to breaks and the html is doing the best job it can.

The only option you may like to consider is to put search for really long words and to hyphenate them.

However, is this a real issue on your site - what are people entering???

levi_501_dehaan

aloha,

well you could always do this.
how big is your table size?
put that in a string called length.
then
you could either,
$result = chunck_split($ResultArray [4], $length)
this will insert \r\n even $length characters

or even put <br> at the end of each split
$result = chunck_split($ResultArray [4], $$length, "<br>")

then you could print it.
have fun dude.