POP up XLS file for Table Result

[ab4net]

HI,
i want my client to be able to click on a bot. or a link ...
and then he get a pop-up to save a file of CSV or XLS which contains the full data (all rows available) in the table 'A' of Database 'DB' this table contains the fields: ID, NAME, TEL

am using the way of showing the rows :

$dbconnect=mysql_connect("localhost","user","pass");
$dbselect=mysql_select_db("DB");
$statement="SELECT *FROM A";
$result=mysql_query($statement);

while ($row=mysql_fetch_array($result)){
echo ($row[id].",&nbsp;".$row[name].",&nbsp;".$row[tel]."<br>");
}

please advice ....
and thanks alot in advance ...

[ab4net]

oh,
sorry i have tried to make script open a file (either XLS or CSV) on the localhost and write the result into it, and thats work, but the problem now, how to make it a pop up for download ...?
any ideas .. ?

[cmdr_bond]

You'd want to change the document headers so it'll think that you actually have an xls file. Try these:

header("Content-type: application/octet-stream");

[ab4net]

and how i can post the new headers ..?
i mean where this peace of code should be stay . ?

thanks in advance ...