Re: csv export...?

Hi David, On Fri, Jan 09, 2004 at 11:04:21AM -0500, David T-G wrote: > Tristan -- > > % Now I have found loadsa sites that let me upload a csv file, but not the > % other way around... > > You might check PHPClasses to see if anyone has done this; I wouldn't be > surprised. In general, though, you declare the file type and then run > through a loop. From some code I have: > > header ("Content-Type: application/csv;") ; # this is a CSV > header ("Content-disposition: attachment; filename=authorized-visitors.$d.csv") ; # > file name > ... > [suck in file and dump into $a array] > foreach ( array_keys($a) as $ak ) # walk thru the array > { print "\"$a[$ak]\"," ; } # print the field (yes, even if > blank) But this would go wrong if $a[$ak] contained a double quote. Remember you have to escape those characters. Can't the database of OP do a dump, like MySQL can? [ rest of script stripped ] -- Regards, Andre