Download the query result ?

[chartahir]

I want to download a query result in an Excel file format,
I can create an excel format file. but i want to work like that:
as the user clicks on the button/link the generte a file and give user the option to save it on his/her system.

I can create file but how to download ?

[Jelena]

you will need something like this:

header("Element Type: HTTPHeader");
header("Content-Type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=file_name.csv");
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: private");

@readfile("path_to_the_file"); 

[Raju Gautam]

        $filename = "ip_pdf.xls";
        header('Content-type: application/vnd.ms-excel');
        header('Content-Disposition: attachment; filename="' . $filename . '"');
        readfile($filename);
        exit(); 

[chartahir]

thanks.