$sqlworker="select * from YuanGong WHERE 1 ";
$sqlworker .= ($code) ? " AND code='$code'";
$sqlworker .= ($name) ? " AND name like '%$name%'";
$sqlworker .= ($alias) ? " AND alias like '%$alias%'";
$sqlworker .= ($code) ? " AND sex='$sex'";
$sqlworker .= ($polifaceID) ? " AND polifaceID='$polifaceID'";
$sqlworker .= ($termID) ? " AND termID='$termID'";
$sqlworker .= ($departID) ? " AND departID='$departID";不过我在想
你那些看起来像整型的字段是不是应该不要单引号?
$sqlworker .= ($code) ? " AND code='$code'";
$sqlworker .= ($name) ? " AND name like '%$name%'";
$sqlworker .= ($alias) ? " AND alias like '%$alias%'";
$sqlworker .= ($code) ? " AND sex='$sex'";
$sqlworker .= ($polifaceID) ? " AND polifaceID='$polifaceID'";
$sqlworker .= ($termID) ? " AND termID='$termID'";
$sqlworker .= ($departID) ? " AND departID='$departID";不过我在想
你那些看起来像整型的字段是不是应该不要单引号?
if($code)
$sqlworker.="code='".$code."' and ";
if($name)
$sqlworker.="name like '%$name%' and ";
if($alias)
$sqlworker.="alias like '%$alias%' and ";
if($sex!=0)
$sqlworker.="sex=".$sex." and ";
if($polifaceID!=0)
$sqlworker.="polifaceID=".$polifaceID." and ";
if($termID!=0)
$sqlworker.="termID=".$termID." and ";
if($departID!=0)
$sqlworker.="departID=".$departID." and ";
if($workID!=0)
$sqlworker.="workID=".$workID." and ";
if($dutyID!=0)
$sqlworker.="dutyID=".$dutyID." and ";
if($height)
$sqlworker.="height>='".$height.'" and ";
if($lawID)
$sqlworker.="lawID=".$lawID." and ";
if($specialty)
$sqlworker.="specialty='".$specialty."' and ";
if($gradscho)
$sqlworker.="gradscho like '%$gradscho%' and ";
if($special)
$sqlworker.="special like '%$special%' and ";
if($hometown)
$sqlworker.="hometown like '%$hometown%' and ";
if($homeaddr)
$sqlworker.="homeaddr like '%$homeaddr%' and ";
if($linktel)
$sqlworker.="linktel='$linktel'";看一下我的代码有什么错?
这行错~~应改为
$sqlworker.="height>='".$height."' and ";