Emailing contents from a MySQL Query

[Anon]

I am using PHP to email the contents of a database query in MySQL.

When I bring back the data from a text field that has linefeed codes "\n\n", they are ignored and treated as ascii text characters in the email message.

I have tried different field types in the database and get the same results.

If I create the same text in a PHP variable inlucding the linefeed codes it works fine.

Any suggestions?

Thanks.

[cvincent]

Does the text come back from the database with line breaks or does it come back with the ascii? You can manually substitute the ascii \n\n with real line breaks before puting it in the email by doing ereg_replace("\n", "\n", $text); or use preg_replace if it is an array that contains your text.

-Chris

[Anon]

It comes back just as ascii and I was able to replace the line breaks as suggested.

It thought that perhaps I was just setting up the database field or query wrong and that I was just missing something.

Thanks.