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!!

[!--sizeo:2--][span style="font-size:10pt;line-height:100%"][!--/sizeo--][!--fonto:Arial--][span style="font-family:Arial"][!--/fonto--][!--coloro:blue--][span style="color:blue"][!--/coloro--]"Experience is a wonderful thing. It enables you to recognize a mistake when you make it again".
[!--sizec--][/span][!--/sizec--][!--colorc--][/span][!--/colorc--][!--fontc--][/span][!--/fontc--]