10 ORDER BY upper_update DESC";
$rst = mysqli_query($con,$sql);
$size = mysqli_num_rows($rst);
$sql1 = "SELECT * FROM shop WHERE (shop_subarea_1 =8 OR shop_subarea_2 =8) AND shop_publish=1 AND shop_course>10 ORDER BY upper_update DESC";
$rst1 = mysqli_query($con,$sql1);
$size1 = mysqli_num_rows($rst1);
$sql2 = "SELECT * FROM shop WHERE shop_area =8 AND shop_publish=1 AND shop_course=10 ORDER BY upper_update DESC";
$rst2 = mysqli_query($con,$sql2);
$size2 = mysqli_num_rows($rst2);
$size = $size + $size1 + $size2;
////////// エリア読み込み //////////
$area_sql = "SELECT * FROM area WHERE area_id =8";
$area_result = mysqli_query($con,$area_sql);
while($area_data = mysqli_fetch_array($area_result)){
$area_id = $area_data["area_id"];
$area_link_url_1 = $area_data["area_link_url_1"];
$area_link_text_1 = $area_data["area_link_text_1"];
$area_link_url_2 = $area_data["area_link_url_2"];
$area_link_text_2 = $area_data["area_link_text_2"];
$area_link_url_3 = $area_data["area_link_url_3"];
$area_link_text_3 = $area_data["area_link_text_3"];
$area_link_url_4 = $area_data["area_link_url_4"];
$area_link_text_4 = $area_data["area_link_text_4"];
$area_link_url_5 = $area_data["area_link_url_5"];
$area_link_text_5 = $area_data["area_link_text_5"];
$area_name_en = $area_data["area_name_en"];
$area_name_jp = $area_data["area_name_jp"];
}
if($area_link_url_1 and $area_link_text_1) {
$area_link_1 = "✿ {$area_link_text_1}
";
}
if($area_link_url_2 and $area_link_text_2) {
$area_link_2 = "✿ {$area_link_text_2}
";
}
if($area_link_url_3 and $area_link_text_3) {
$area_link_3 = "✿ {$area_link_text_3}
";
}
if($area_link_url_4 and $area_link_text_4) {
$area_link_4 = "✿ {$area_link_text_4}
";
}
if($area_link_url_5 and $area_link_text_5) {
$area_link_5 = "✿ {$area_link_text_5}";
}
if($area_link_url_1 and $area_link_text_1) {
$area_link = <<< SET