New lines/Carriage Returns

[Dan400007]

I've written a small questionnaire in PHP. Several questions are to be completed in a text box. All data enters ok, but when I retrive the results with the following:

$query = 'SELECT * INTO OUTFILE "C:\\inetpub\\intranet\\results\\'.$qnamed.''.$filenamedate.'.csv" fields terminated by "," lines terminated by "\n" FROM '.$qnamed.'';

I encounter a problem. If the user completing the questionnaire has started a new line in the text box, then the file starts a new line every time a user did. Since I want to put this straight into excel (hence the .csv) it completly destroys the structure.

I have tried to adding $question1 = trim($question1); when they are completing the questionnaire but it hasn't helped.

Thanks for any help, Dan.

[halojoy]

• \n

• \r

• <br>

and also combinations of them, with double or single slash (escape)
can be used in HTML, PHP, text files and other documents
also can be different from OS to OS, Windows or Linux

There is no real Accepted standard for this ( like DVD or CD-Audio )

This requires mostly some tests and strip/add convert knowledge
from us php scripters.
To incorporate in our code to assure correct formatting of string data.
Especiallly if we intend to release php script applications to users for internet downloads.
They might have many different setup environments.