Enum database search
Posted: Fri Oct 29, 2004 5:41 am
hi there!
I hope someone can help me... I have a hotel database with over 100 field headings and 3000 rows.
The field headings are all facilities such as tennis, creche, restaurant etc...
The values under each heading for all 3000 hotels are either Y or N, indicating whether or not a specific hotel has each specific facility.
I want to put a search box on my site using this information, where a user can type one or more keywords, eg. tennis, creche, golf and get a list of hotels which matches.
But i can't work out how to do it!! I've been searching all the forums but no luck. I'd be grateful if anyone could point me in the right direction! Thanks very much!
LizzyD
(P.S Some headings say stuff like "Iron / Ironing Board" - I'd also like, if possible for the search to work if someone enters Iron, or if they enter Ironing Board - is this possible??)
I hope someone can help me... I have a hotel database with over 100 field headings and 3000 rows.
The field headings are all facilities such as tennis, creche, restaurant etc...
The values under each heading for all 3000 hotels are either Y or N, indicating whether or not a specific hotel has each specific facility.
I want to put a search box on my site using this information, where a user can type one or more keywords, eg. tennis, creche, golf and get a list of hotels which matches.
But i can't work out how to do it!! I've been searching all the forums but no luck. I'd be grateful if anyone could point me in the right direction! Thanks very much!
LizzyD
(P.S Some headings say stuff like "Iron / Ironing Board" - I'd also like, if possible for the search to work if someone enters Iron, or if they enter Ironing Board - is this possible??)