I currently have two tables in my MySQL database.
City and Hotel are the tables.
I have several rows of hotels which includes fields such as hotel_id, hotel_name, hotel_address.
I want these hotels to be associated to the cities and display 3 hotels for each city…
Therefore in the City table i have i have included 3 fields called hotel_1, hotel_2 and hotel_3.
In each of the field i have placed the ID (hotel_id) of the hotel i want to display.
I want write a query that will display the hotels for that city.
Please help!
