CSV download - no data

[jpaym]

Hi,

I'm trying to export data from postgresql table to CSV file so that the users can download CSV file.

I'm using,

header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:filename=test.xls");

BUT when I download the CSV file, it contains NO data.

I've checked my sql query and there seems to be nothing wrong.. Could anyone please help me?

[pnoeric]

Forget the download part-- if the MySQL query is ok, then look at the file on the disk and be sure it's written out ok. The mechanism to download the file is a pretty straightforward file transport in the browser; I doubt it's failing... more likely, the SQL query is buggy, or the code to write the result set to test.xls is buggy.

good luck,
Eric