<?php
                //Table selection If statement
        if ($_POST['MailingSelection']  == 'Sponsors') {
            $Table = Sponsors;
        }
        else {
            $Table = Members;
            }
            
        include_once("dbconnect.php");

        $result = mysql_query("SELECT * FROM $Table", $con);
        $count = mysql_num_fields($result);

        for ($i = 0; $i < $count; $i++){
            $header .= mysql_field_name($result, $i)."\t";
        }

        while($row = mysql_fetch_row($result)){
             $line = '';
          foreach($row as $value){
            if(!isset($value) || $value == ""){
                  $value = "\t";
        }else{
        # important to escape any quotes to preserve them in the data.
              $value = str_replace('"', '""', $value);
        # needed to encapsulate data in quotes because some data  might be multi line.
        # the good news is that numbers remain numbers in Excel even though quoted.
              $value = '"' . $value . '"' . "\t";
            }
            $line .= $value;
          }
          $data .= trim($line)."\n";
        }
        # this line is needed because returns embedded in the data have "\r"
        # and this looks like a "box character" in Excel
          $data = str_replace("\r", "", $data);
        
        # This line will stream the file to the user rather than spray it across the screen
        header("Content-type: application/vnd.ms-excel");

        # replace excelfile.xls with whatever you want the filename to default to
        header("Content-Disposition: inline; filename=".$_POST['MailingSelection'].".xls");

        echo $header."\n".$data;
        ?>

$result = mysql_query("Select * from regionalstaff",$link);
        
$header = "<table border='0' cellpadding='0' cellspacing='0'>";

while ($row = mysql_fetch_array($result)) {
     $header .= "<tr><td>". $row["id"] . "</td></tr>";
}

$header .= "</table>";
        

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

echo $header;