Button to echo $variable to browser?

fmedina

How can I echo my variable $table to the browser from a page like so:

header("Content-Type: application/vnd.ms-excel; name='excel'");
header("Content-Disposition: attachment; filename=filename.xls");

echo ("$table");
The variable $table contains and html table.

I want every report page to contain a button so that people can export the report to Excel by clicking on it. But I can't figure out if I have to submit to another page that does this or what? thanks,

danielle

if the report table is already in a database
this is how i did it:

then in export.php put the header:
<?header("Content-Type: application/vnd.ms-excel");
header("Content-Disposition: inline; filename=\"tablename.xls\"");

include "access.php";

$q="select * from ext_resources where dept='$pg_src'";
$r=mysql_query($q);

mysql_pconnect ("localhost", "xxx", "xxx"); //connect to database

mysql_select_db ("xx") or die ("Unable to select database");
$q="select * from tablename where report='$report_key'";
$r=mysql_query($q);

echo ("Item#". "\t" ..."\n");

while
($array_exp=mysql_fetch_array($r)) {

    echo ($array_exp["item_num"]. "\t" ... "\n");

}//end while

danielle

sorry, skip the first

include "access.php";

$q="select * from ext_resources where dept='$pg_src'";
$r=mysql_query($q);