include "../manager/common/common.php"; DBopen(); $sYear = ($search_fun != "EXEC") ? date("Y"): $sYear; $where = ($sYear != "") ? "and lastupdate like '%".$sYear."%'": ""; if (trim($search_item) != "" && trim($item_str) != "") $where.= "and ".$search_item." like '%".$item_str."%'"; else if (trim($search_item) == "" && trim($item_str) != "") $where.= "and (news_title like '%".$item_str."%' or news_detail like '%".$item_str."%') "; $list_sql = "select * from news_list where fKoukai='1' and site_kubun='".$site_kubun."' ".$where." order by lastupdate desc"; ?>