Hmm to do a search on one table it might actually be quicker to do a query
for every thing in the query. First convert to all lowercase. Then explode
the query into an array using " " as the delimiter. Then implode this array
into a list that looks something like this. "var1","var2"...) you c
Disclaimer: Its late, I'm tired and I haven't tested this code. Hope it
helps.
Quick Overview:
//make your dictionaries all lower case for ease
$countries = array( 1 => 'us', 2 => 'germany', 3 => 'australia' );
$cities = array( 1 => 'new york', 2 => 'berlin', 3 => 'sydney' );
$lodging = array(
