Page 1 of 1

Problem with obtaining data *SOLVED*

Posted: Wed May 12, 2004 5:42 am
by dakkonz
is there anyway of exporting the data in the MYSQL database out as an excel spreadsheet for the user to download??

Posted: Wed May 12, 2004 7:29 am
by kettle_drum
Well you could just get the data from the database and make it into a csv file - just have [data], [data], [data], etc.

Posted: Wed May 12, 2004 7:36 am
by magicrobotmonkey
http://us3.php.net/com

look at the first user added comment

Posted: Wed May 12, 2004 8:23 am
by launchcode
dakkonz - you can only do this reliably on a Windows server, otherwise you need to look at exporting as CSV.

Posted: Wed May 12, 2004 8:46 am
by dakkonz
i am not using a windows server.....so how do i export as csv data?

Posted: Wed May 12, 2004 8:48 am
by launchcode
Loads of different ways... write your own function to suck out the data you need, format it in a CSV format and stream it to the browser/save to a file they can download. Or you can make MySQL do a CSV dump directly - but you'll probably have more control in the first instance.

Posted: Wed May 12, 2004 7:59 pm
by dakkonz
kz thx..... :D