include_once("core/config.php"); $clean_destination_name=str_replace("-"," ",$_GET['destinazione']); $query_destination="SELECT * FROM destinations WHERE destination_name='$clean_destination_name'" or die("Error in the consult.." . mysqli_error($link)); $destination_data=mysqli_query($link_companies_data, $query_destination); while($data=mysqli_fetch_array($destination_data)) { $destination_id=$data['destination_id']; $destination_name=$data['destination_name']; $destination_code=$data['destination_code']; $destination_tagline=$data['destination_tagline']; $destination_intro=$data['destination_intro']; $destination_desc=$data['destination_desc']; } //Tutte le città della destinazione///////////////////////////////////////////////////////////////////////// $query_countries="SELECT dep_port FROM msc_itinerary WHERE area_dest='$destination_code' GROUP BY dep_port"; $countries_data=mysqli_query($link_cruises, $query_countries); while($data_countries=mysqli_fetch_array($countries_data)) { $cities_codes[]=$data_countries['dep_port']; } $cities_codes_string=implode("','",$cities_codes); $cities_codes_string_2="'".$cities_codes_string."'"; $query_cities="SELECT city_code, city_name FROM cities WHERE city_code IN($cities_codes_string_2)"; $cities_data=mysqli_query($link_companies_data, $query_cities); //////////////////////////////////////////////////////////////////////////////////////////////////////////// ?>