[SOLVED] CSV writing

[PC Nerd]

Hi,

 

Im looking for a way to write to a CSV file.

 

I can get the writing working, but i cant seem to find out how to get the records seperated.  at the moment the firlds are placed correctly "value, value, value" - however the next record only continues on the same line when veiwed in MS Office Excel.

 

How can I create the newline?

 

thanks

[PC Nerd]

*** UPDATE:

 

echoing: "\n"; at the end of the record foesnt work - it actually echos out as the characters "\" and "n".

 

is this because o fht encoding or somethign eg ASCI etc???

 

 

thanks

[btherl]

Try echoing "\n" instead of '\n'.  Double quotes are necessary for those special characters.

[PC Nerd]

<?php

 

$lastname = "ME";

$firstname = "NAME";

$email = "email@domain.com";

 

if(is_writable('TEST.csv')) {

 

$fp = fopen('TEST.csv','a');

$content = "$lastname,$firstname,$email\n";

fwrite($fp,$content);

 

 

fclose($fp);

 

}

 

?>

 

thats what ive got - and its working.

 

 

Thanks

 

 

 

Thanks

[~n[EO]n~]

I changed this and it is working for me, you should give a try 

$content = "$lastname,$firstname,$email" . "\r\n";

[btherl]

That looks fine then.. how did you find that it was printing \ and n instead of \n?

 

Oh, and try neon's suggestion   \r\n is the windows end-of-line