yeah that is what i meant, having different boxes coming in. sorry if i didnt make myself clear!
i have managed to sort it now i am using the code....
SELECT * FROM hotels WHERE (hotelname LIKE \'%$hotelplace%\' OR hoteladdress LIKE \'%$hotelplace%\' OR hotelcountry LIKE \'%$hotelplace%\' OR hotelphone LIKE \'%$hotelplace%\') AND (hotelcountry LIKE \'%$country%\') AND (hotelrating LIKE \'%$rating%\') LIMIT 0, 50
which works nicely!!
All i gotta sort out now is what happens if the user enters a comma or other punctuation on the search field!!
cheers
RF