object("cs_gameng", "where 1"); $search = $_GET[search]; $area1 = $_GET[area1]; $searchkey = $_GET[searchkey]; if($searchkey=='1') { $search_db = "name like '%".$search."%' or area1 like '%".$search."%'"; } else if($searchkey=='2') { $search_db = "area1 like '%".$area1."%'"; } else { $search_db = " 1"; } $g_table = "cs_gameng"; $total_cnt = $db->cnt($g_table, "where 1"); $seoul_cnt = $db->cnt($g_table, "where area1 like '%서울%'"); $gy_cnt = $db->cnt($g_table, "where area1 like '%경기%'"); $bu_cnt = $db->cnt($g_table, "where area1 like '%부산%'"); $inchun_cnt = $db->cnt($g_table, "where area1 like '%인천%'"); $daegu_cnt = $db->cnt($g_table, "where area1 like '%대구%'"); $daejun_cnt = $db->cnt($g_table, "where area1 like '%대전%'"); $ulsan_cnt = $db->cnt($g_table, "where area1 like '%울산%'"); $kang_cnt = $db->cnt($g_table, "where area1 like '%광주%'"); $sejong_cnt = $db->cnt($g_table, "where area1 like '%세종%'"); $kn_cnt = $db->cnt($g_table, "where area1 like '%경남%'"); $kb_cnt = $db->cnt($g_table, "where area1 like '%경북%'"); $jn_cnt = $db->cnt($g_table, "where area1 like '%전남%'"); $jb_cnt = $db->cnt($g_table, "where area1 like '%전북%'"); $cn_cnt = $db->cnt($g_table, "where area1 like '%충남%'"); $cb_cnt = $db->cnt($g_table, "where area1 like '%충북%'"); $kw_cnt = $db->cnt($g_table, "where area1 like '%강원%'"); $jj_cnt = $db->cnt($g_table, "where area1 like '%제주%'"); ?> select( "cs_gameng", "where $search_db order by idx desc" ); $result_gameng_cnt = $db->cnt( "cs_gameng", "where $search_db order by idx desc" ); while( $row_gameng = mysql_fetch_object($result_gameng)) { $name = $row_gameng->name; $addr = $row_gameng->addr; $phone = $row_gameng->phone; $lat = $row_gameng->lat; $lng = $row_gameng->lng; $result_ga .= "['',".$lat.",".$lng."],"; ?>