Save mySQL data into a CSV file.
| From: | Martin E. Koss | Date: | Mon, 16 Jun 2003 12:53:26 +0000 |
| Subject: | Save mySQL data into a CSV file. | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-28640@lists.php.net to get a copy of this message | ||
Hi,
I have a table with 1,008 columns in it and at it's peak it has up to 500
rows of data.
I want to enable my client to click on a link and the next thing they are
prompted with is 'Save or Open' (the CSV file).
The data will be compiled into a comma delimited CSV file but rather than be
printed to the screen it would be best if the browser popped up asking where
to save the 'filename.csv' file to. Once saved, the file can be opened in
Excel for analysis.
Where do I start to do this?
Thanks
Martin