Radioactive Frog

yeah i managed to do it using preg_remove(); RF

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

i have the following query SELECT * FROM hotels WHERE hotelname LIKE \'%$search%\' OR hotelcountry LIKE \'%$search%\' OR hoteladdress LIKE \'%$search%\' i have one search value coming in....but what if there is $search2 AND OR $search3 ..... please could someone enlighten me on this.... thanks p.s. one of the values coming in would be a INT if it makes any difference !! dont worry, sorted it !! thanks

great that works for that, but what about if i had to search variables coming in? how would i incorporate that? i have tried a couple of things but they dont work any ideas? thanks again

thanks i will try it, j is only a test to see if it works i will put a \'%$search%\' there when i put it on the php page !! thanks again

yeah i had changed that, sorry i should have saidm but it doesnt make any difference

that doesnt show any results when i test it in phpmyqdmin

i have this query for searching one field SELECT * FROM `hotels` WHERE hotelname LIKE \'%j%\' at it works ok, but i would like to search say two more fields i thought it would be like below but that dont work please could someone point out where i am going wrong....thanks SELECT * FROM `hotels` WHERE hotelname OR hotelcountry OR hoteladdress LIKE \'%j%\' thanks