I am currently running a project for a tour operator, I want to link the database as follows:
Continents Page > Countries Page > Locations Page > Hotel Brochure Page
e.g: Europe > England > London > London Hotel
How can I do this? Do I need multiple dynamic pages or multiple databases?
I need the location pages to show the two hotels from that specific location (location is a field in my database)
I need the hotel page to display up to 10 images in a carousel and also display the hotels description and room features.
At the minute my database looks like this:
Continent Country Location Hotel Description Image 1 Image 2 Image 3
and so on...