Jump to content


Photo

two+ search fields - how to query?


  • Please log in to reply
4 replies to this topic

#1 Radioactive Frog

Radioactive Frog
  • Members
  • PipPip
  • Member
  • 20 posts
  • LocationEngland

Posted 18 December 2003 - 11:14 PM

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
[a href="http://www.wildhosting.co.uk" target="_blank"]Wild Hosting[/a] :: [a href="http://www.brandstar.co.uk" target="_blank"]Brandstar UK Ltd[/a]

#2 perplexed

perplexed
  • Members
  • Pip
  • Newbie
  • 2 posts

Posted 22 December 2003 - 12:44 PM

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

#3 Radioactive Frog

Radioactive Frog
  • Members
  • PipPip
  • Member
  • 20 posts
  • LocationEngland

Posted 23 December 2003 - 12:08 AM

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
[a href="http://www.wildhosting.co.uk" target="_blank"]Wild Hosting[/a] :: [a href="http://www.brandstar.co.uk" target="_blank"]Brandstar UK Ltd[/a]

#4 Hokus

Hokus
  • Members
  • PipPip
  • Member
  • 23 posts
  • LocationAlameda, CA, USA

Posted 23 December 2003 - 06:44 AM

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

This can be done pretty easily with regex.
[!--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--]

#5 Radioactive Frog

Radioactive Frog
  • Members
  • PipPip
  • Member
  • 20 posts
  • LocationEngland

Posted 23 December 2003 - 09:20 AM

yeah i managed to do it using preg_remove();

RF
[a href="http://www.wildhosting.co.uk" target="_blank"]Wild Hosting[/a] :: [a href="http://www.brandstar.co.uk" target="_blank"]Brandstar UK Ltd[/a]




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users