php编程SQL语句union all的使用编程

Question

id分别是ishijian1，ishijian2，语句是<?php

echo ' ';

?>

<td  valign="top" style="width:903; " >

起始时间
截止时间

c_huizong.php
<?php
//订单查询
if ($_POST['1shijian1'])
{
echo "<br> document.getElementById(&#39;1shijian1&#39;).value=&#39;&quot;.$_POST[&#39;1shijian1&#39;].<br> &quot;&#39;;document.getElementById(&#39;1shijian2&#39;).value=&#39;&quot;.$_POST[&#39;1shijian2&#39;].<br> &quot;&#39;;cg1name();";

if ($_POST['1shijian1']<>NULL)
$shijian1=" and COPTC.TC003>=".$_POST['1shijian1'];
else
$shijian1="";

if ($_POST['1shijian2']<>NULL)
$shijian2=" and COPTC.TC003<=".$_POST['1shijian2'];
else
$shijian2="";

require_once('i_code/connect.php');

$query="select leixing,xifen,sewen,ddgm,bztdb,daba,SUM(TD008) AS TD008,SUM(TA015)TA015,SUM(RKZS)RKZS,SUM(D310)D310,SUM(D305)D305,SUM(D304)D304,SUM(D3023)D3023,SUM(TH008)TH008,SUM(TJ007)TJ007
FROM chaxun
LEFT JOIN DDTJMX ON MA003=leixing and xifen=XIFEN AND sewen=DDTJMX.UDF10 AND ddgm=DDGM and daba=XINGHAO
left join COPTC on TC001=DDTJMX.TD001 AND TC002=DDTJMX.TD002
where xifen<>'' and xifen<>'5050' and TC003>='20150110' AND TC003<='20150120'
GROUP BY leixing,xifen,sewen,ddgm,bztdb,daba
union all
select leixing,xifen,null as sewen,null as ddgm,bztdb,null as daba,SUM(TD008) AS TD008,SUM(TA015)TA015,SUM(RKZS)RKZS,SUM(D310)D310,SUM(D305)D305,SUM(D304)D304,SUM(D3023)D3023,SUM(TH008)TH008,SUM(TJ007)TJ007
FROM chaxun
LEFT JOIN DDTJMX ON MA003=leixing and xifen=XIFEN
left join COPTC on TC001=DDTJMX.TD001 AND TC002=DDTJMX.TD002
where xifen='5050' and TC003>='20150110' AND TC003<='20150120'
GROUP BY leixing,xifen,bztdb
union all
select leixing,null as xifen,null as sewen,null as ddgm,bztdb, null as daba,SUM(TD008) AS TD008,SUM(TA015)TA015,SUM(RKZS)RKZS,SUM(D310)D310,SUM(D305)D305,SUM(D304)D304,SUM(D3023)D3023,SUM(TH008)TH008,SUM(TJ007)TJ007
FROM chaxun
LEFT JOIN DDTJMX ON MA003=leixing
left join COPTC on TC001=DDTJMX.TD001 AND TC002=DDTJMX.TD002
where xifen='' and TC003>='20150110' AND TC003<='20150120'
GROUP BY leixing,bztdb".$shijian1.$shijian2;

$result=mssql_query($query);
$row_num=mssql_num_rows($result);
if ($row_num<=10000 && $row_num>0)
{
echo "

";
echo ";
;
;
;
;
;
;
;
;
;
;
;
;
";

while($row=mssql_fetch_assoc($result))
{
echo"

";

echo"

";
echo"";
echo"";
echo"";
echo"";
echo"";
echo"";
echo"";
echo"";
echo"";
echo"";
echo"";
echo"";
//跟踪信息

echo"</tr> \n";

}
echo"

类别	细分	色温	订单规模	标准投单比	打靶	订单量	预计产量	总入库数	标准入库	销货数量	销退数量	跟踪信息
".$row['leixing']."	".$row['xifen']."	".$row['sewen']."	".$row['ddgm']."	".$row['bztdb']."	".$row['daba']."	".number_format($row['TD008'],0)."	".number_format($row['TA015'],0)."	".number_format($row['RKZS'],0)."	".number_format($row['D310'],0)."	".number_format($row['TH008'],0)."	".number_format($row['TJ007'],0)."	跟踪信息

 

";
echo'';

}

mssql_close($conn);

}
?>

现在一运行语句是错的，是后面的语句里面的查询语句有错，求指正。

Answer 1

不懂你要问什么。
而且，你这代码一大堆，完全没法看啊。建议插入代码片段：

<?php 
    // ^__^