解决方案 »
- 向discuz数据库中插入数据时。。要更新哪几个表,才能显示呢?。。求高手指点。。高分!!!!!!!!!!!!!!!
- 如何保存客人在外贸网站支付页面填入的信息?
- 异步,js请求,ajax三者?
- html 中js怎么获得后台数据
- 问几个简单的php疑问
- 老是提示如Table 'gongan.wjtz' doesn't exist,可是我的库gongan中有表wjtz啊!
- 娃哈哈,新年开始,这么多招聘的?
- 请教大哥们?
- 提问:关于PHP连接SQL SERVER的问题
- windows下file_uploaded_file权限问题
- php切割txt文档可以按KB切割吗
- 点击表格行(学生姓名)时显示对应的层(学生信息),当点击其他行时原层的隐藏问题
<?PHP$id=$_GET['number'];include("conn.php");$Date = date("YmdHis");
$Filename = $Date.".csv";
$Table = isset($_GET['tid'])?$_GET['tid']:'';
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:filename=".$Filename);
echo "SKU,product-name,sum(quantity),\r\n";
$Sql = "select *,sum(`quantity-purchased`) from sale_orders WHERE `number`=$id group by `jj_sku`";
$Result = mysql_query($Sql);
while($rs = mysql_fetch_array($Result) ){
$j_sku=$rs['jj_sku'];
$Sqlpr = "SELECT `product-name` FROM `product_co` WHERE `jj_sku`=`$j_sku`";
$Resulta = mysql_query($Sqlpr,$conn);
$resultaa= mysql_fetch_row($Resulta);
$pro-nm=$resultaa[0]; echo $rs['jj_sku'].",".$pro-nm.",". $rs['sum(`quantity-purchased`)']." \r\n ";
}
$j_sku=$rs['jj_sku'];
$Sqlpr = "SELECT `product-name` FROM `product_co` WHERE `jj_sku`=`$j_sku`";
$Resulta = mysql_query($Sqlpr,$conn);
$resultaa= mysql_fetch_row($Resulta);
$pro-nm=$resultaa[0];
这段代码删除就可以
#1特意把字号加大了,还看不清吗?