=current_date AND $sql = "SELECT * FROM recruit, shop WHERE recruit.rec_shop_id=shop.shop_id AND recruit.rec_taigu_4=1 AND shop_publish=1 AND shop_course>9 ORDER BY upper_update DESC"; $rst = mysqli_query($con,$sql); $size = mysqli_num_rows($rst); ////////// エリア読み込み ////////// $area_sql = "SELECT * FROM area WHERE area_id >0"; $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"]; } $title = "朝・昼に働けるお店一覧 | 【京町ばいと】京都の風俗求人・ナイトワーク情報"; include("./temp.php"); echo $head; echo $search_result_header; ?>