$accom_row[name]"; } //get additional accommodation data from database $addi_q = mysqli_query($con, "SELECT a.name FROM `additional_accomm` a INNER JOIN `room_additionalAccom` raddi ON a.id = raddi.additionalAccom_id WHERE raddi.room_id = '$room_data[id]'"); $additionalAccom_data = ""; while($addi_row = mysqli_fetch_assoc($addi_q)){ $additionalAccom_data .="$addi_row[name]"; } //get cover image $room_cover = ROOM_IMG_PATH."logo.png"; $cover_q = mysqli_query($con, "SELECT * FROM `room_images` WHERE `room_id`='$room_data[id]' AND `upload`='1'"); if(mysqli_num_rows($cover_q) > 0){ $cover_res = mysqli_fetch_assoc($cover_q); $room_cover = ROOM_IMG_PATH.$cover_res['image']; } //display room (---**accommodation section did not use from database**---) echo <<< data data; } ?>