On Wed, Oct 22, 2008 at 10:15 PM, Jason Todd Slack-Moehrle
<[EMAIL PROTECTED]> wrote:
> On Oct 22, 2008, at 6:58 PM, Stut wrote:
>
>> On 23 Oct 2008, at 02:41, Jason Todd Slack-Moehrle wrote:
>>>
>>> Actually i am ending the row headers with a chr(10); // LINE FEED
>>
>> From the code you included in your original post...
>>
>>> echo "/n";
>>
>>
>> There was no mention of chr(10).
>>
>> Outputting data in CSV format is not hard. Simply echo the header row if
>> necessary, followed by "\n". Then output each line taking care to put string
>> values in quotes which means you also need to escape quotes in the data.
>> After each line echo "\n". That's really all there is to it.
>>
>> If you're still having problems I suggest you post the exact code you're
>> using, anything else just makes it harder for us to provide effective help.
>>
>> -Stut
>>
>>> On Oct 22, 2008, at 5:12 PM, Stut wrote:
>>>
>>>> On 23 Oct 2008, at 00:59, Jason Todd Slack-Moehrle wrote:
>>>>>
>>>>> After I right out the column headers do I have to put a '/n' to have it
>>>>> start a new line in the CSV file? I think I do.
>>>>
>>>> A new line is \n not /n, and it must be in double quotes (") not single
>>>> (').
>>
>
> Oh, I am not putting quotes around each field that i get from MySQL. There
> are no quotes in the data so that is good.
>
> Sorry I put "/n" and I meant to put chr(10).
>
> -Jason
>
Jason, one of the points that Stut was trying to explain is that "\n"
and chr(10) are the same thing. They are just two different ways to
refer to a newline (line feed) character. Most of us probably use "\n"
rather than chr(10) in PHP, though. So, the following two lines are
equivalent:
<?php
echo "Item1, Item2, Item3" . chr(10);
// Note this uses double quotes.
echo "Item1, Item2, Item3\n";
// It won't be the same at all if you use single quotes
echo 'Item1, Item2, Item3\n';
?>
At any rate, you are correct that you need a line feed/newline
character at the end of every row in CSV including the header row.
Andrew
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
