search form query results

[vinpkl]

hi all

i m working on search form query.

query="SELECT * FROM product_table where product_name LIKE '%$keyword%'";

i have Product name "Genuine Nokia DC4 charger for N95" in database.

My search query dont show results for keywords

1) DC4 car charger
2) DC4 charger Nokia
3) Genuine DC4 Charger
4) DC4 Genuine Charger

whats the solution.

vineet

[johanafm]

'%' matches any number of characters. So '%DC4 car charger%' matches

[any number of characters of any kind]DC4 car charger[any number of characters of any kind]

-- for example
abcdefg124342 DC4 char charger!"#€%&

-- but NOT
123 DC4 car THIS IS NOT A MATCH charger

Now, I've no idea what DB you are using, but I'd take a wild guess at MySQL, and if that's correct you will find your answer here: MATCH AGAINST

[vinpkl]

hi johanafm

as directed by you i was trying the match against query

$query="SELECT * FROM product_table WHERE MATCH(product_name) AGAINST('$keyword')";

its giving me error
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource

vineet

johanafm;10928209 wrote:

'%' matches any number of characters. So '%DC4 car charger%' matches

[any number of characters of any kind]DC4 car charger[any number of characters of any kind]

-- for example
abcdefg124342 DC4 char charger!"#€%&

-- but NOT
123 DC4 car THIS IS NOT A MATCH charger

Now, I've no idea what DB you are using, but I'd take a wild guess at MySQL, and if that's correct you will find your answer here: MATCH AGAINST

[NogDog]

To find out the exact problem, check to see if the return value from mysql_query() is false, and if so either echo mysql_error() or use log_error(mysql_error()) to log it.

My guess is that either the table being searched is not using the MyISAM engine, and/or you did not assign a FULLTEXT index to the column being matched.

[vinpkl]

hi NogDog

I applied fulltext index to the column and now the error is gone.

But now if i enter "DC4 charger" the i get results shown for all chargers whether they are dc4 or not.

and if i enter only DC4 then no result is shown.

$query="SELECT product_name FROM product_table WHERE MATCH(product_name) AGAINST('$keyword')";

is there any solution by which i can get results for product names that contains both the two words DC4 and charger like the product name is "genuine dc4 charger" or "dc4 genuine charger".

vineet

NogDog;10928217 wrote:

To find out the exact problem, check to see if the return value from mysql_query() is false, and if so either echo mysql_error() or use log_error(mysql_error()) to log it.

My guess is that either the table being searched is not using the MyISAM engine, and/or you did not assign a FULLTEXT index to the column being matched.

[johanafm]

If you continue reading the documentation at the url I provided, you would have found boolean mode

SELECT * FROM articles WHERE MATCH (title,body)
AGAINST ('+MySQL +PostgreSql' IN BOOLEAN MODE);

Now you'd get only stuff containing BOTH MySql AND PostgreSql

[vinpkl]

hi johanafm

i dont know why its happening. i m still getting showed all chargers.

$query="SELECT product_name FROM product_table WHERE MATCH(product_name) AGAINST('+dc4 +charger' IN BOOLEAN MODE)";

vineet

johanafm;10928222 wrote:

If you continue reading the documentation at the url I provided, you would have found boolean mode

SELECT * FROM articles WHERE MATCH (title,body)
AGAINST ('+MySQL +PostgreSql' IN BOOLEAN MODE);

Now you'd get only stuff containing BOTH MySql AND PostgreSql

[vinpkl]

hi johanafm

i found the problem.

The problem is that the Boolean mode is not accepting numeric characters.

if i enter "+Nokia +Charger" then i get results acording to both nokia and charger only.

But if i enter any word that contain numeric character like "dc4" or "acc3" then results dont match the two words are show extra chargers.

Does boolean has something to do with numeric characters.

vineet

[johanafm]

No, it should match digits as well, but there is a setting regarding minimum length of the words matched. Anything shorter than this length is simply dropped from the query. I believe it's set to 3 by default, but I might be wrong on this. Check your mysql config settings.