insert and retrieve text

extremed · 12-03-2010, 04:37 PM

Hi

Im inserting formatted text using textarea to mysql field and text is looks like

Code:

first line
second line
third line

once i retrieve this text, its looks like

Code:

first linesecond linethird line

how to keep the format when retrieve?

Any help would be great, sorry for the language errors

Thanks

kbluhm · 12-03-2010, 04:49 PM

Are they being echoed within a loop? I notice there are no spaces between the 3 lines, which would be the case if you were viewing it within a browser with no break tags.

Otherwise, you are echoing each line with no new line characters in between.

Care to show us your code?

extremed · 12-03-2010, 05:06 PM

Quote:

Originally Posted by kbluhm

Are they being echoed within a loop? I notice there are no spaces between the 3 lines, which would be the case if you were viewing it within a browser with no break tags.

Otherwise, you are echoing each line with no new line characters in between.

Care to show us your code?

no loop since i retrieve one raw
im echo it back to a textarea