Jump to content

two+ search fields - how to query?


Radioactive Frog

Recommended Posts

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

Link to comment
https://forums.phpfreaks.com/topic/1528-two-search-fields-how-to-query/
Share on other sites

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.