Search Problem

[andyy15]

I was wondering if anyone could help me out with this problem. Here it is... When I search for an item say I enter "rings" the search turns up both "earrings" and "rings". I only want the search to turn up rings and not display earrings. Does anyone know how to fix this search algorithm problem? I have isolated it to this code:

 if (isset($search_keywords) && (sizeof($search_keywords) > 0)) {
   $where_str .= " and (";
   for ($i=0, $n=sizeof($search_keywords); $i<$n; $i++ ) {
     switch ($search_keywords[$i]) {
       case '(':
       case ')':
       case 'and':
       case 'or':
         $where_str .= " " . $search_keywords[$i] . " ";
         break;
       default:
         $keyword = tep_db_prepare_input($search_keywords[$i]);
         $where_str .= "(pd.products_name like '%" . tep_db_input($keyword) . "%' or p.products_model like '%" . tep_db_input($keyword) . "%' or m.manufacturers_name like '%" . tep_db_input($keyword) . "%'";
         if (isset($HTTP_GET_VARS['search_in_description']) && ($HTTP_GET_VARS['search_in_description'] == '1')) $where_str .= " or pd.products_description like '%" . tep_db_input($keyword) . "%'";
         $where_str .= ')';
         break;
     }
   }
   $where_str .= " )";
 }

Thanks,
Andrew

[robbiesmith79]

Just take out the %'s in the following lines:

$where_str .= "(pd.products_name like '%" . tep_db_input($keyword) . "%' or p.products_model like '%" . tep_db_input($keyword) . "%' or m.manufacturers_name like '%" . tep_db_input($keyword) . "%'";
if (isset($HTTP_GET_VARS['search_in_description']) && ($HTTP_GET_VARS['search_in_description'] == '1')) $where_str .= " or pd.products_description like '%" . tep_db_input($keyword) . "%'";
$where_str .= ')';

to read:

$where_str .= "(pd.products_name like '" . tep_db_input($keyword) . "' or p.products_model like '" . tep_db_input($keyword) . "' or m.manufacturers_name like '" . tep_db_input($keyword) . "'";
if (isset($HTTP_GET_VARS['search_in_description']) && ($HTTP_GET_VARS['search_in_description'] == '1')) $where_str .= " or pd.products_description like '" . tep_db_input($keyword) . "'";
$where_str .= ')';

The % is a SQL wildcard character. If you searched for "rings" with the new script... you'll get "rings".

Robbie Smith
Azurite Design
Azurite Design - Sarasota and Bradenton Web Sites
O: 941-580-3452
C: 941-735-5592

[robbiesmith79]

My bad. the keyword LIKE is used in tandom with the %'s. If you take out the %'s, then the LIKE needs to be a '=' to get exact matches.