Re: [PHP-DB] mysql to cvs file to excel

2003-02-23 Thread Ruth Zhai
This is what I use to generate a comma delimited csv file: $sql = "SELECT * FROM table INTO OUTFILE 'file.csv'" ." FIELDS TERMINATED BY \',\'" ." ENCLOSED BY \'\"\'"; Hope this helps. Ruth - Original Message - From: "Snijders, Mark" <[EMAIL PROTECTED]> T

RE: [PHP-DB] mysql to cvs file to excel

2003-02-21 Thread Bruno Pereira
I had the some problem and someone told me this "What is your problem exactly? Have you investigated the MySQL manual under: LOAD DATA INFILE SELECT ... INTO OUTFILE ?" And it realy helped. Cumprimentos Bruno Pereira [EMAIL PROTECTED] -Original Message- From: Snijders, Mark [mailto:[E