是不是高手进来就知道了

Question

本帖最后由 qwe_121 于 2010-11-08 14:35:36 编辑

Answer 1

$res= mysql_query($sql);
if (mysql_num_rows($res)>1)
{
    header("Content-type:application/vnd.ms-excel");
    header("Content-Disposition:attachment;filename=$type-$start_jf-$end_jf.xls");
    header("Content-type: text/html; charset=utf8");
  echo   iconv('utf-8','gb2312',"订单号")."\t";
echo   iconv('utf-8','gb2312',"操作人员")."\t";
echo   iconv('utf-8','gb2312',"时间")."\t";
echo   iconv('utf-8','gb2312',"记录")."\t";
echo   iconv('utf-8','gb2312',"备注")."\t";
echo   "\n";
while ($row =mysql_fetch_array($res)) {
echo   iconv('utf-8','gb2312',$row['order_id'])."\t";
echo   iconv('utf-8','gb2312',$row['person'])."\t";
echo   iconv('utf-8','gb2312',$row['date'])."\t";
echo   iconv('utf-8','gb2312',$row['record'])."\t";
echo   iconv('utf-8','gb2312',$row['res'])."\t";
echo   "\n";
}     
}
else 
{
echo '没有数据';
}改成这样