<?php
//Hotel Detail
$rbhotel     = mysqli_query($conn, "SELECT ho.hotel_name, ho.hotel_information, ho.hotel_address, ho.hotel_state, ho.hotel_zipcode, ho.hotel_stars, ho.hotel_reviews, ho.hotel_main_image, ci.city_name, ci.country_code, ho.longitud, ho.latitud FROM hotels AS ho JOIN cities AS ci ON ho.hotel_city = ci.city_id WHERE ho.hotel_id = '$id' ");
$rbhotelData = mysqli_fetch_array($rbhotel);

$hotelname        = $rbhotelData['hotel_name'];
$hoteldescription = $rbhotelData['hotel_information'];
$hoteladdress     = $rbhotelData['hotel_address'];
$hotelcity        = $rbhotelData['city_name'];
$hotelstate       = $rbhotelData['hotel_state'];
$hotelzip         = $rbhotelData['hotel_zipcode'];
$hotelcountrycode = $rbhotelData['country_code'];
$hotelrating      = $rbhotelData['hotel_stars'];
$hotelreview      = $rbhotelData['hotel_reviews'];
$hotelat          = $rbhotelData['latitud'];
$hotelon          = $rbhotelData['longitud'];
$hotelid          = $id;
?>