CodeIgniter Forums

Full Version: crlf in mysql
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

I have an emailtext model that I'm using to send emails, but keep the content in one place and replace the items that need replacing in the code. So i put a template into mysql and I'm having trouble getting carriage return line feeds out of the message.

When it was in code, I would have: "Line 1\r\nLine 2".

I need to be able to insert text into my database and have it come out like that. I put that text in and I just see actual \r\n in the text of the email.

How can I go about putting CRLF into mysql?