1) { $searchresult = $searchresult."and (area='".$check_area[0]."' "; for($check_area_i=1;$check_area_i<$num_area;$check_area_i++) { $searchresult = $searchresult."or area='".$check_area[$check_area_i]."' "; } $searchresult = $searchresult.") "; } else { $searchresult = $searchresult." and area='$area' "; } } $sql = "select * from df_agency"; $sql .= " Where 1 = 1 "; if($area) { $sql .= $searchresult; } if($area_sido) $sql.= " and area_sido = '$area_sido'"; if($name) $sql.= " and name like '%$name%'"; $sql .= " order by area_sido asc"; if ($_SERVER['REMOTE_ADDR']=='180.228.124.230') { echo $sql; } $result = mysql_query($sql) or error(mysql_error()); $rows = 8; $lists = 5; $today = date("Ymd"); $total = mysql_num_rows($result); $page_count = ceil($total/$rows); if(!$page || $page > $page_count) $page = 1; $start = ($page-1)*$rows; if($start>1) mysql_data_seek($result,$start); while(($row = mysql_fetch_object($result)) && $rows){ ?>

지역	시/군/구	지점명
area?>	area_sido?>	name?>