A couple of things to bear

webwiz — Mon, 28 Jan 2008 05:58:18 +0000

A couple of things to bear in mind with CSV files:

Any field containing a comma also needs quotes around it
Double any quotes that may occur inside such a quoted field

But you probably already knew that.

I never knew that function

pr0gr4mm3r — Mon, 28 Jan 2008 04:13:31 +0000

I never knew that function existed. When I need to output a csv-formatted file, I just echo everything as plain text and format it manually.

How you write the csv file?

carloncho — Sun, 27 Jan 2008 18:55:03 +0000

How you write the csv file? with fputcsv function?

pr0gr4mm3r — Wed, 21 Nov 2007 21:59:00 +0000

Putting the fields in quotes should do the trick.

Here is a sample:

"this
is
a
test","hello"
"how are
you?","I am
fine"

Here is the result:

Greg K — Wed, 21 Nov 2007 04:05:52 +0000

I'm not sure if it can be done. The only thing I can think of is try running phpMyAdmin, create a sample table, then go to EXPORT and choose Excel format, and instead of telling excel to open the file, tell it to open in notepad to see how that formats them....

If I think about it tomorrow and get time, I'll play around with it and se what I can come up with.

-Greg