Search module only displays 100%
Posted: Wed Aug 29, 2007 8:58 am
When I insert a searchword like animal, the module only displays results with pages that contain animal.
But I also want words linke animalfarm is in the search results.
I think it is in this query:
I replaced WHERE into LIKE, but that doen's work.
How can I make the module searches less rigourous and also returns words that contain the searchstring?
But I also want words linke animalfarm is in the search results.
I think it is in this query:
Code: Select all
$query = "SELECT DISTINCT i.module_name, i.content_id, i.extra_attr, COUNT(*) AS nb, SUM(idx.count) AS total_weight FROM ".cms_db_prefix()."module_search_items i INNER JOIN ".cms_db_prefix()."module_search_index idx ON idx.item_id = i.id WHERE (".$searchphrase.") ANDÂ (".$db->IfNull('i.expires',$db->DBTimeStamp(100 * 100 * 100 * 100 * 25))." > ".$db->DBTimeStamp(time()).") ";How can I make the module searches less rigourous and also returns words that contain the searchstring?