two+ search fields - how to query?

[Radioactive Frog]

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

[perplexed]

cant you have different text boxes from your form i.e. you have search as the name or one text box, call another.... ? searchcountry etccc..

[Radioactive Frog]

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

[Hokus]

Why not eliminate their ability to enter other chars then AZ and 0-9.

 

This can be done pretty easily with regex.

[Radioactive Frog]

yeah i managed to do it using preg_remove();

 

RF