i need to have dynamic drop down menus which in themselves are easy however my delima is that i have two menus and the second one needs a filter from the first menu
Menu One lists all the Regions from a table called Region
Menu two should list Hotels from the region that was selected in Menu One
the database layout is
Region Table:
RegionID
CountryID
Region
Hotel Table
SiteID
Site Name
Region ID
Country ID
any help would be appreciated or even base code layout