header csv, asks for password in excel

[algorithm]

Hey, so Ive created an export data script that links to my mysql database and constructs a csv document (using headers) to export the data. This works fine in all browsers except IE, where it would actually ask the user for my mysql username and password to open the csv spreadsheet. Pressing 'cancel' allows the user to see the spreadsheet, but I'd like to open the csv file without this password nonsense in IE. Any solutions?

[kenrbnsn]

Code?

[algorithm]

here is my header

 

header("Content-type: application/");
header("Content-disposition: csv" . date("Y-m-d") . ".csv");
header("Content-disposition: filename=".$filename.".csv");
print $csv_output;

[kenrbnsn]

How do you build $csv_output? What's the value of $filename?

 

If you had posted the whole script, I wouldn't have to ask these questions. Also, others would be able to run the script on their machines to try to replicate the problem and, perhaps, see where the problem is occurring.

 

Ken