MySQL "TEXT" and formatting...

[Mr_Mako]

Hi.

I have a site I'm working on and at one point the users can enter text in the input string. I have the MySQL field as "TEXT".

However, when anyone enters text into the field there, the output basically just gets "jumbled" together. For example, if I type up a couple paragraphs with indents and spacing, the indents and spacing don't seem to get saved... as the output when viewed has the entire text entry as one big lump of text.

Is there a way to change this? I'd really like to be able to keep the formatting of the text once the data is entered into the database so it's much easier to view when someone selects the output on the webpage after inputting the text.

Mako

[xblue]

most probably all the spaces and line breaks are still there (unless you stripped them manually), it is just that the browser ignores them.

if only line breaks are needed to be displayed properly, nl2br() is made for this.

but if you need the indentation to be displayed, you might want to use the <pre> </pre> html tags.