Page 1 of 1

Full Text Search Help!

Posted: Sun Jul 09, 2006 3:59 pm
by zink
Hey

Having big time problems with my full text search on my site. Think its a pretty easy one though for you PHP gurus :wink:

The following query does not bring back any records but they are definitely there!! For example the category field contains the words "Designer Men" and the brand is "Duck And Cover" (in the mySQL db). This code is a direct copy of another query but for "ladies ladie women women's" and it works prefectly this is why i do not understand it!!

Here is the offender:

Code: Select all

$num3 = getPORProducts("SELECT * FROM por WHERE MATCH(longDescription, category, description, brand, name) AGAINST('+\"Duck & Cover\" \"Duck and Cover\" \"Duck & Cover\" +(mens men\'s men)' IN BOOLEAN MODE)");
p.s. to save you some time the problem is definitely with the code above, and has nothing to do with the functions i have created.

Cheers for your help!
-Zink

Posted: Sun Jul 09, 2006 4:45 pm
by feyd
full-text search & query = Databases. Moved.

Posted: Sun Jul 09, 2006 4:54 pm
by zink
Feel free to help feyd :lol: ?

Posted: Mon Jul 10, 2006 4:13 am
by zink
bump :cry:

Posted: Mon Jul 10, 2006 2:54 pm
by zink
hey i figured this out if anyone is interested!

Basically there is a minimum character limit of 4. and i was trying to bring back results using a 3 character string "men". This server variable "ft_min_word_len" can be updated but it has to be done at mySQL server startup. Unfortunately I am on a shared platform and cant see my host doing this for me. :lol:

Cheers