　お仕事情報　件ヒットしました！

10 ORDER BY shop_course DESC, upper_update DESC LIMIT $size) UNION (SELECT * FROM shop WHERE (shop_subarea_1 =4 OR shop_subarea_2 =4) AND shop_publish=1 AND shop_course>10 ORDER BY upper_update DESC LIMIT $size) UNION (SELECT * FROM shop WHERE shop_area =4 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_publish = $data["shop_publish"]; $shop_name = $data["shop_name"]; $shop_code = $data["shop_code"]; $shop_tel = $data["shop_tel"]; $shop_pref = $data["shop_pref"]; $shop_pref_jp = pref_jp($shop_pref); $shop_pref_en = pref_en($shop_pref); $shop_genre = $data["shop_genre"]; $shop_genre_name = genre_name($shop_genre); $shop_area = $data["shop_area"]; $shop_subarea_1 = $data["shop_subarea_1"]; $shop_subarea_2 = $data["shop_subarea_2"]; $shop_subarea_1_text = $data["shop_subarea_1_text"]; $shop_subarea_2_text = $data["shop_subarea_2_text"]; $shop_addr= $data["shop_addr"]; $shop_pr = $data["shop_pr"]; $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_search_message = $rec_data["rec_search_message"]; ////////// 店舗メッセージ・文字数制限設定 ////////// $rec_message_goldvip = mb_strimwidth($rec_message, 0, 200, "...","UTF-8"); $rec_message_platinum = mb_strimwidth($rec_message, 0, 200, "...","UTF-8"); $rec_message_standard = mb_strimwidth($rec_message, 0, 200, "...","UTF-8"); $rec_message_subarea = mb_strimwidth($rec_message, 0, 200, "...","UTF-8"); $rec_message_free = mb_strimwidth($rec_message, 0, 200, "...","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_goldvip = 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_goldvip = 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_goldvip = 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"]; } //////////インタビュー読み込み////////// $interview_on = ""; $interview_shop_id = ""; $interview_sql = "SELECT * FROM interview WHERE interview_shop_id ='".$shop_id."'"; $interview_result = mysqli_query($con,$interview_sql) or die(mysqli_error()); while($interview_data = mysqli_fetch_array($interview_result)){ $interview_id = $interview_data["interview_id"]; $interview_shop_id = $interview_data["interview_shop_id"]; } if($interview_shop_id ==$shop_id ){ $interview_on = "1"; } //////////衣装読み込み////////// $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_pref = $costume_data["costume_pref"]; $costume_pref_en = pref_en($costume_pref); $costume_name_en = $costume_data["costume_name_en"]; $costume_name_jp = $costume_data["costume_name_jp"]; } //////////アイコン設定////////// $icon=""; $two=""; if($rec_taigu_1 or $rec_taigu_4 or $rec_taigu_23 or $interview_on>0){ $icon.="

"; if($rec_taigu_1){ $icon.= <<< SET LINE応募