Hi, the basic search on my site is too specific.. Meaning it's too exact with word order and phrases.
For example, if I search Shoes Red it won't show results for Red Shoes.
If you search for Red Shoe Laces it won't show results for Red Laces (as the word shoe throws off this order). Below is the code that I believe the search box is using. Can anyone tell me how to "loosen" up this search so it's either more broad or so exact word order isn't necessary?
This is the current code:
case 'search': if (intval($filter) != 0) { $filter = JString::strtolower($filter); $id = intval($filter); $search .= $temp."(a.id = $id OR LOWER(a.ad_headline) LIKE '%".$this->_db->getEscaped($filter,true)."%' OR LOWER(a.ad_text) LIKE '%".$this->_db->getEscaped($filter,true)."%')"; } else { $filter = JString::strtolower($filter); $search .= $temp."(LOWER(a.ad_headline) LIKE '%".$this->_db->getEscaped($filter,true)."%' OR LOWER(a.ad_text) LIKE '%".$this->_db->getEscaped($filter,true)."%')"; } break; } } } return $search; }
Need Help With SQL Code For Basic Search
Posted - 02/06/2013 : 11:36:48
