Mysql 'text' field

[Anon]

Hi,

I have a php form that inputs the data from a 'textarea' field called 'description' to a mysql table with a 'text' field of the same name.

How do I get the mysql text field to keep the same formatting as input by the user, eg. line spacing, carriage returns etc...

Could it be the problem is with my php form stripping out line breaks and extra spaces before inputting the data ?

Cheers.

[Anon]

Hi

You can use:

$textfield = nl2br( $textfield );

This is an a php function and replace every newline in field with a tag html <br>.
I think this is a solution for you.

Bye.
jazzo.

[phlow]

you could also use <pre></pre> in your html code, but jazzo's way is better.

[Anon]

Thanks alot !

That has fixed my problem 🙂

Cheers.