I have a simple form for customer service where a user enters their issue. When the issue is replied to, an email is sent (via PHP mail) with the answer to the question along with the entire thread on the bottom.
The problem is everything displays fine on the web...
$query="UPDATE email_customer_service set datetime='$datetime', order_no='$order_no', message='Customer Service Reply - $datetime EST\n\n$reply\n\n\n\n$message', assign_to='$assign_to', status='completed' where thread_id='$thread_id'";
but when the thread history is emailed all the \n linebreaks are gone. Basically, what the message part of the query is doing is adding the reply with a header and timestamp to the original message and saving it in the database. I've tried making that field a longblob and a longtext type, but it doesn't seem to make a difference.
Note: When viewing the contents of the field through a mysql editor when it was longblob, I did notice that the linebreaks were preserved when viewing it in Rich Text, but were not for text.
Any ideas???? I hate these little frustrating issues.
Thanks.
Ryan
