[RESOLVED] Strange string problem from database.

errorCode30

Alright all,

I'm having a strange problem from a string im calling from a database:

Database:

Comments varchar(255) latin1_swedish_ci

The problem is...

most comments will split when the lengh of the container div is reached:

This is my comment
it is great that my
text is splitting!

BUT for some strange reason, certain comments are just comming out as a long line:

This is my comment it is great that my text is splitting!

There are no line breaks in the text to make the strings split, i just thought seen as over 3000 do, why are like a certain number not?

Any inbuilt php code to stop that happening?

Many thanks.

sid

could you provide us with some samples (maybe parts of the database dump) of comments that do get split up and comments that dont? did you examine the html source code that's sent to the browser?

nemonoman

A likely cause of this behavior might be the method used to input the text: different text areas in different browsers. Text areas for input use the WRAP attribute to set line breaks; you can set the attribute to HARD, SOFT, or NONE. Different browsers set this attribute's default behavior differently.

You can set some structure on the problem by manually setting the WRAP attribute of the textarea:

http://www.idocs.com/tags/forms/_TEXTAREA_WRAP.html

bradgrafelman

If you want to force a line break after so many characters, you can use a function such as [man]wordwrap[/man]. There are solutions on the board that show how to use this function without splitting a word as well.

If you're talking about a DIV with a fixed width with automatically wrapping text, then there's nothing PHP can do - you'll need to modify the HTML/CSS for that.