RE: [PHP-DB] Reporting tool for stats pulled from MySQL db

This is the easiest way but depending on what brouser you use and what version of excel you have the results vary somewhat, try using Content-Disposition: inline and then saving the the file from there, this works best for me, but its by no means perfect. I seem to recall that someone posted a php class on here that would output in excel format correctly but it only works if your using IIS etc. hope this helps -----Original Message----- From: Lisi [mailto:lists@shemeshdirectory.co.il] Sent: 25 February 2003 09:41 To: PHP-DB Subject: [PHP-DB] Reporting tool for stats pulled from MySQL db I have a stats tracking program and a page that displays stats for various dates/items depending on what options the user selects. I need to add some kind of external reporting tool, i.e. they'd like to download the information, preferably in Excel. I tried forcing Excel to open the data instead of the browser by sending headers: Header("Content-Type: application/vnd.ms-excel"); Header("Content-Disposition: attachment; filename='stats.xls'"); When I sent just the first one, all I got was a blank broswer page with a picture (application?) icon in the top left hand corner. Then I added the second header, which I found in a previous post in the archives, and that forced a download but of the page itself (stats_print.php). 1) What am I doing wrong? 2) Every posting I found in the archives said this is the easiest way. Is there another, harder but might work for me, way anyone would suggest of doing this? Thanks in advance, -Lisi -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php