CodeIgniter Forums
crlf in mysql - Printable Version

+- CodeIgniter Forums (
+-- Forum: Archived Discussions (
+--- Forum: Archived Development & Programming (
+--- Thread: crlf in mysql (/thread-27508.html)

crlf in mysql - El Forum - 02-12-2010

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?