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

In the first line, what do you mean where the file is? Where I want it to be? It doesn't exist yet, I want to generate an Excel file from dynamic data. And I don't want it to be saved on the server, I just want the user to download it. Anyway, I tried changing Header("Content-Disposition: attachment; filename='stats.xls'"); to Header("Content-Disposition: inline; filename='stats.xls'"); without adding any of your other changes but I got the same icon in the corner. I'm using IE 6. -Lisi At 09:46 AM 2/25/03 +0000, George Pitcher wrote:

Lisi, This is a modification of a script I use to download pdfs. It might just work <?php $fpd = "E:\\MyFolder\\" . $fp . ".xls"; // where the file is $len = filesize($fpd); header("Content-Type: application/vnd.ms-excel"); header("Content-Disposition: inline; filename=$fpd"); header("Content-Title: $fpd"); header("Content-Length: $len"); readfile($fpd); ?> George -----Original Message----- From: Lisi [mailto:lists@shemeshdirectory.co.il] Sent: 25 February 2003 9:41 am 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