已经解决了.我写出来,也可以给其他人参考一下.只是还不明白为什么 order by跟查询语句一起写就会出问题. for($i=0;$i<count($keywords);$i++)
{
if($i==0)
$query = "select * from football where $searchtype like '%".$keywords[$i]."%' ";
else
$query = $query."UNION select * from football where $searchtype like '%".$keywords[$i]."%'";
}
$query.= "ORDER BY datetime DESC,time DESC"; //order by 分开写就好了
{
if($i==0)
$query = "select * from football where $searchtype like '%".$keywords[$i]."%' ";
else
$query = $query."UNION select * from football where $searchtype like '%".$keywords[$i]."%'";
}
$query.= "ORDER BY datetime DESC,time DESC"; //order by 分开写就好了
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货