View Single Post
  #1  
Old 07-08-2003, 12:43 PM
 
harold5370 harold5370 is offline
 

Newbie
  
Join Date: Jun 2003
Location: Moreno Valley, CA.
Posts: 7
 

Default Problems with Searching Extra Fields

I am trying to extend the functionality of the search by setting param00 to a lsit of keywords which I can search on.. I have modified the following line
Code:
$substring_condition = ($substring==""?"":"and ($sql_tbl[products].product like '%$substring%' or $sql_tbl[products].descr like '%$substring%') ");

to this

Code:
$substring_condition = ($substring==""?"":"and ($sql_tbl[products].product like '%$substring%' or $sql_tbl[products].descr like '%$substring%' or $sql_tbl[products].param00 like '%$substring%') ");

but I still can not seem to return any results to match the text in the keywords (param00) field. Does anyone have experience or suggestions with this?
Reply With Quote