Thread: Search Problem
View Single Post
  #1  
Old 07-07-2004, 05:16 PM
 
serpentware serpentware is offline
 

Newbie
  
Join Date: Mar 2004
Posts: 6
 

Default Search Problem

Hey I'm trying to make my search work so that when a user types a query, xcart doesn't search just the title, and desciptions for matches, but also my field - param01. So I can keep categorization info in there that isn't seen by the user. However I modded Search.php (as below) and I still can't get it to work. Any ideas, anyone?

Code:
$substring_query = "AND ($sql_tbl[products].product like '%$substring%' OR $sql_tbl[products].descr like '%$substring%' OR $sql_tbl[products].fulldescr like '%$substring%' OR $sql_tbl[products].param01 like '%$substring%')";

I also added the phrase, " OR $sql_tbl[products].param01 like '%$substring%' " in the if statement above.

Am I putting this in totally the wrong place, or what?

I have x-cart Pro. 3.4.1

Thanks,
Sam[/code]
Reply With Quote