Like %% SQL

Manat

Hello all,

I have a search tool on my extranet. when someone enters a keyword in the searchbox, the $keyword parameter is taken and SQL-ed.

Now, I want to instead of where table.keyword='$keyword', I want to do where table.keyword LIKE '%$keyword%'.

But when I changed the code, I always got weird results. I am supposed to have 10 results per page, after the change I got 5 results per page with 'some' keywords, not all.

Here is my SQL:

$get_data = mysql_query("SELECT keywords.*, Product.*, Price_Range.* FROM keywords, Price_Range, Product WHERE keywords.keyword = '$keyword' AND keywords.sku = Product.SKU  AND Product.Price_Range_ID = Price_Range.Price_Range_ID AND Product.Is_Active=1") or die(mysql_error());

that $keyword, all I did was change it to where keywords.keyword LIKE '%$phrase%'

Did I do the change wrong?
anyone know why I would get odd results counts?

Thanks
MK

eoghain

What data are you submitting? If you are submitting a list of keywords then using LIKE %$keywords% will only match when the words you are entering appear exactly like they were typed with anything infront or behind them.

So if I was searching for "hot pink pants" using your LIKE query I'd only get results that have the phrase "hot pink pants" exactly in it's keywords. I wouldn't get any results that just had pants, hot, or pink in the keywords, or results that had all three words but not in the order I typed them with spaces in between.

It looks to me like you have a table of key words that you want to compair against a list of words that a user will type into a field, if this is the case you would probably be better off using IN and parsing what your user submits into a comma separated list.

bobbythenewb

I'm finding this a bit strange. I'm using a very basic query and getting inconsistent results.

OMG I've spent hours trying to work out what I was about to paste and the moment I start typing in here the solution just popped into my head and its working sweet.

OH SWEET JESUS I BELIEVE IN THE MIRACULOUS!!!!!

thanks for lending me your ears and consciousness willing helpers! yeeeeehaa I can sleep now 😃