<?php

include($_SERVER['DOCUMENT_ROOT'].'/dbinfo.inc.php'); $mysqli=mysqli_connect('localhost',$username,$password,$database); mysqli_set_charset($mysqli,"utf8"); if (mysqli_connect_errno()) { trigger_error('Database connection failed: ' . mysqli_connect_error(), E_USER_ERROR);} 

$query="SELECT countries_divided.*, ahotels.area_name, area_name2, ahotels.area_name_path, ahotels.city_id, city_name, city_links, city_name_lower, city_name_path, agoda_cities.city_recommended, ad1_url, img2, map, state_name, state_name_lower, ahotels.country_id, ahotels.country_name, ahotels.country_name_lower, ahotels.continent_name, ahotels.continent_name_lower FROM ahotels 

LEFT JOIN agoda_cities ON ahotels.city_id = agoda_cities.city_id 
LEFT JOIN ahotels_img ON ahotels.hotel_id = ahotels_img.hotel_id 
LEFT JOIN agoda_areasx ON ahotels.area_id = agoda_areasx.area_id 
LEFT JOIN countries_divided ON ahotels.country_id = countries_divided.country_id AND regexp_cd LIKE CONCAT('%',LEFT(ahotels.city_name_lower , 1),'%')
WHERE ahotels.area_name_path='asiahotels/japanhotels/matsumotohotels/ikusakahotels' AND ahotels.accommodation_type = 'Hotel'
ORDER BY img2, user_rating_average, user_rating_average > 9.2 
LIMIT 1";

$result = mysqli_query($mysqli,$query) or trigger_error("Query Failed! SQL: $query - Error: ". mysqli_error($mysqli), E_USER_ERROR);
while($row = mysqli_fetch_assoc($result)) {
    
$ad1_url = $row['ad1_url'];
$map = $row['map'];
$img2 = $row['img2'];
$area_id = '565290'; 
$area_name2 = $row['area_name2'];
$area_name = $row['area_name'];
$area_name_lower = 'ikusaka';
$area_name_path = $row['area_name_path'];
$city_recommended = $row['city_recommended'];
$city_links = $row['city_links'];
$city_name = $row['city_name'];
$city_name_lower = $row['city_name_lower'];
$city_name_path = $row['city_name_path'];
$country_name = $row['country_name'];
$country_divided_path = $row['country_divided_path'];
$atoz_cap = $row['atoz_cap'];
$state_name = $row['state_name'];
$state_name_lower = $row['state_name_lower'];
$continent_name = $row['continent_name'];
$country_name_lower = $row['country_name_lower'];
$continent_name_lower = $row['continent_name_lower'];
$city_id = $row['city_id'];
$country_id = $row['country_id'];

$accommodation_type = 'Hotel';
$accommodation_type_plur = 'Hotels';
$area_by_type_name_path = 'asiahotels/japanhotels/matsumotohotels/ikusakahotels1';
$city_by_type_name_path = 'asiahotels/japanhotels/matsumotohotels/matsumotohotels1';
if(!empty($area_name2)) :
$area_name = $area_name2;
else :
$area_name = $row['area_name'];
endif;
include($_SERVER['DOCUMENT_ROOT'].'/fluidarea_by_type2.php');}    
 
?>