Keyword Search for multiple words

[Keendev]

Hi,

I just made a keyword search into my dynamic site and is working just fine for a one word

Problem is if I search for "rich famous" word..my search result doesn't return any. But if I search for "rich" or "famous" only... my search page return a result.

need help on this..

thanks a lot.

 

[jpadie]

you need to do something like this

$column = 'fieldName';
$keywords = explode(" ", $_POST['keywords']);
foreach ($keywords as &$kw){
 $kw = "$column like '%".mysql_escape_string($kw)."%'";
}
$query = "Select * from table where ".implode(" OR ", $keywords);

this assumes a free text keywords search. you should make sure that you have an FT index on this column.

if you use proper keyword tagging you will store the keywords in a join table. in which case you should use an IN comparison rather than a like. the format is different but the process is the same as that posted above.