Carriage Returns in MySQL/PHP

[Aludaan]

Hello,

I was making a form that stores a 'Notes' field using a HTML textfield. The problem is that when I store it in MySQL and then retrieve it later, it comes out in one long paragraph. Any carriage returns that were entered before were dropped.

ie. If someone typed:
Hello.
My name is Aludaan.

it is displayed as:
Hello.My name is Aludaan.

Is there a way to make either MySQL save it with carriage returns or PHP to enter <br> commands where people enter carriage returns?

Thanks,

Aludaan

[devinemke]

the newlines are still there, you are just not seeing them in your browser. pull the data out of the db and run it thru [man]nl2br[/man].