Hey
Having big time problems with my full text search on my site. Think its a pretty easy one though for you PHP gurus
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:
$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