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

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

echo ‘ ‘;

?>

<code><td valign="top" style="width:903"></code>

c_huizong.php
<?php
//订单查询
if ($_POST[‘1shijian1’])
{
echo “
document.getElementById('1shijian1').value='".$_POST['1shijian1'].
"';document.getElementById('1shijian2').value='".$_POST['1shijian2'].
"';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_num0)
{
echo “

;

;

;

;

;

;

;

;

;

;

;

;

;

“;

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

echo”

“;
echo”

“;
echo”

“;
echo”

“;
echo”

“;
echo”

“;
echo”

“;
echo”

“;
echo”

“;
echo”

“;
echo”

“;
echo”

“;
echo@本文来源gaodai$ma#com搞$代*码6网搞代gaodaima码“

“;
//跟踪信息

<code>echo"</tr> \n";</code>

}
echo”

“;
echo”;

}

mssql_close($conn);

}
?>

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