9 ORDER BY upper_update DESC"; $rst = mysqli_query($con,$sql); $size = mysqli_num_rows($rst); $sql1 = "SELECT * FROM shop WHERE shop_area =7 AND (shop_genre =11 OR shop_genre =10 OR shop_genre =14) AND shop_publish=1 AND shop_course=9 ORDER BY upper_update DESC"; $rst1 = mysqli_query($con,$sql1); $size1 = mysqli_num_rows($rst1); $size = $size + $size1; //////////　エリア読み込み　////////// $area_sql = "SELECT * FROM area WHERE area_id =7"; $area_result = mysqli_query($con,$area_sql); while($area_data = mysqli_fetch_array($area_result)){ $area_id = $area_data["area_id"]; $area_name_en = $area_data["area_name_en"]; $area_name_jp = $area_data["area_name_jp"]; } //////////　地域+業種読み込み　////////// $area_genre_sql = "SELECT * FROM area_genre WHERE area_genre_id =120"; $area_genre_result = mysqli_query($con,$area_genre_sql); while($area_genre_data = mysqli_fetch_array($area_genre_result)){ $area_genre_id = $area_genre_data["area_genre_id"]; $area_genre_name_en = $area_genre_data["area_genre_name_en"]; $area_genre_name_jp = $area_genre_data["area_genre_name_jp"]; } $title = "{$area_genre_name_jp} ｜【京町ばいと】京都の風俗求人・ナイトワーク情報"; include("./temp.php"); echo $head; echo $search_result_header; ?>

トップページ ≫

の募集情報

件ヒットしました！

10 ORDER BY shop_course DESC, upper_update DESC LIMIT $size) UNION (SELECT * FROM shop WHERE shop_publish=1 AND (shop_genre =11 OR shop_genre =10 OR shop_genre =14) AND (shop_subarea_1 =7 OR shop_subarea_2 =7) AND shop_course>10 ORDER BY upper_update DESC LIMIT $size) UNION (SELECT * FROM shop WHERE shop_area =7 AND (shop_genre =11 OR shop_genre =10 OR shop_genre =14) AND shop_publish=1 AND shop_course=10 ORDER BY upper_update DESC LIMIT $size) LIMIT $start,$max_1p"); while($data = mysqli_fetch_array($recordSet)){ $shop_id = $data["shop_id"]; $shop_rank = $data["shop_rank"]; $shop_course = $data["shop_course"]; $shop_name = $data["shop_name"]; $shop_code = $data["shop_code"]; $shop_genre = $data["shop_genre"]; $shop_genre_name = genre_name_sp($shop_genre); $shop_area = $data["shop_area"]; $shop_subarea_1 = $data["shop_subarea_1"]; $shop_subarea_2 = $data["shop_subarea_2"]; $shop_addr= $data["shop_addr"]; $shop_addr2= $data["shop_addr2"]; $shop_pr = $data["shop_pr"]; $shop_tel= $data["shop_tel"]; $shop_line= $data["shop_line"]; $shop_cacao= $data["shop_cacao"]; $shop_costume = $data["shop_costume"]; $nyukin = $data["nyukin"]; $shop_update = $data["shop_update"]; //////////求人情報読み込み////////// $rec_sql = "SELECT * FROM recruit WHERE rec_shop_id ='".$shop_id."'"; $rec_result = mysqli_query($con,$rec_sql) or die(mysqli_error()); $rec_id = ""; $rec_shop_id = ""; $rec_title = ""; $rec_message = ""; $rec_img_main = ""; $rec_syokusyu = ""; $rec_gyosyu = ""; $rec_kyuyo = ""; $rec_shikaku = ""; $rec_kinmuchi = ""; for($i=1; $i<37; $i++){${'rec_taigu_'.$i} = "";} while($rec_data = mysqli_fetch_array($rec_result)){ $rec_id = $rec_data["rec_id"]; $rec_shop_id = $rec_data["rec_shop_id"]; $rec_title = $rec_data["rec_title"]; $rec_message = $rec_data["rec_message"]; $rec_message = str_replace("
", " ", $rec_message); $rec_message_vip = mb_strimwidth($rec_message, 0, 288, "...","UTF-8"); $rec_message_standard = mb_strimwidth($rec_message, 0, 190, "...","UTF-8"); $rec_message_free = mb_strimwidth($rec_message, 0, 190, "...","UTF-8"); $rec_message_sb = mb_strimwidth($rec_message, 0, 110, "...","UTF-8"); $rec_img_main = $rec_data["rec_img_main"]; $rec_syokusyu = $rec_data["rec_syokusyu"]; $rec_kyuyo = $rec_data["rec_kyuyo"]; $rec_kyuyo = str_replace("
", " ", $rec_kyuyo); $rec_kyuyo_vip = mb_strimwidth($rec_kyuyo, 0, 80, "...","UTF-8"); $rec_kyuyo_standard = mb_strimwidth($rec_kyuyo, 0, 70, "...","UTF-8"); $rec_shikaku = $rec_data["rec_shikaku"]; $rec_shikaku = str_replace("
", " ", $rec_shikaku); $rec_shikaku_vip = mb_strimwidth($rec_shikaku, 0, 80, "...","UTF-8"); $rec_shikaku_standard = mb_strimwidth($rec_shikaku, 0, 70, "...","UTF-8"); $rec_kinmuchi = $rec_data["rec_kinmuchi"]; $rec_kinmuchi = str_replace("
", " ", $rec_kinmuchi); $rec_kinmuchi_vip = mb_strimwidth($rec_kinmuchi, 0, 80, "...","UTF-8"); $rec_kinmuchi_standard = mb_strimwidth($rec_kinmuchi, 0, 70, "...","UTF-8"); $rec_taigu_text = $rec_data["rec_taigu_text"]; for($i=1; $i<37; $i++){${'rec_taigu_'.$i} = $rec_data["rec_taigu_{$i}"];} $rec_update = $rec_data["rec_update"]; break; } //////////エリア読み込み////////// $area_sql = "SELECT * FROM area WHERE area_id ='".$shop_area."'"; $area_result = mysqli_query($con,$area_sql); while($area_data = mysqli_fetch_array($area_result)){ $area_id = $area_data["area_id"]; $area_name_en = $area_data["area_name_en"]; $area_name_jp = $area_data["area_name_jp"]; } //////////衣装読み込み////////// $costume_sql = "SELECT * FROM costume WHERE costume_id ='".$shop_costume."'"; $costume_result = mysqli_query($con,$costume_sql); while($costume_data = mysqli_fetch_array($costume_result)){ $costume_name_en = $costume_data["costume_name_en"]; $costume_name_jp = $costume_data["costume_name_jp"]; } //////////　ロイヤルVIP求人掲載コース（ ※ 7/1 リリース予定）　////////// if($shop_course=="30" and $shop_subarea_1<>7 and $shop_subarea_2<>7){ $body.= <<< SET

{$shop_name}