MySQL导出到excle显示不了_mysql导出到excel

$con = mysql_connect("localhost" , "usename" , "password") or die ("Not Fouund" . mysql_error());

mysql_select_db("mydb") or die ("Not Fouund" . mysql_error());

$select = "SELECT * FROM Table_name";

$export = mysql_query($select);

$fields = mysql_num_fields($export);

$header = "" ;

$data = "";

for ($i = 0; $i < $fields; $i++) {

$header .= mysql_field_name($export, $i) . "t";

}

while($row = mysql_fetch_row($export)) {

$line = '';

foreach($row as $value) {

if ((!isset($value)) OR ($value == "")) {

$value = "t";

} else {

$value = str_replace('"', '""', $value);

$value = '"' . $value . '"' . "t";

}

$line .= $value;

}

$data .= trim($line)."n";

}

$data = str_replace("r","",$data);

if ($data == "") {

$data = "n(0) Records Found!n";

}

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

header("Content-Disposition: attachment; filename=AjayExcel.xls");  header("Pragma: no-cache");  header("Expires: 0");  header("Lacation: excel.htm?id=yes"); print "$headern$data";  ?>