Html Clickable To Advanced Search

[ComicWisdom]

The below code will search in both the description and the tags for a product.

 

In the same table (products_description) I have created a field 'products_continent'

does anyone out there give me a hint as to how I can get the below code to also search that field?

 

 

<a href="http://www.mydomain.com/catalog/advanced_search_result.php?keywords=North America&search_in_description=1&search_in_tags=1">North America</a> 

 

Thank you,

Ralph

[user99999999]

The search feature has [ and, or, () ] functionality.

 

	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;
 }
}

 

If you are hard coding links you might want to try using a + instead of a space.

 

Like this

 

Massachusetts+or+MA

[user99999999]

So with that said you would add additional tables to the search like so.

 

advanced_search_results.php ~261

 

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) . "%'";

 

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 .= " or pc.products_continent like '%" . tep_db_input($keyword) . "%'";
}

 

Also add to the $from_str 'products_continent pc'

[ComicWisdom]

One last bit I don't understand about these two lines.

 

$where_str .= " or pd.products_description like '%" . tep_db_input($keyword) . "%'";
$where_str .= " or pc.products_continent like '%" . tep_db_input($keyword) . "%'";

 

Both of these fields are in the same table "products_description"

Why is one line

pd.products_

and the next line

pc.products_

 

Thank you,

Ralph

[user99999999]

Sorry I meant pd.