View Single Post
  #1  
Old 02-04-2003, 10:46 PM
  wayne@industrialeye.com's Avatar 
wayne@industrialeye.com wayne@industrialeye.com is offline
 

Newbie
  
Join Date: Nov 2002
Location: los angeles, california
Posts: 5
 

Default Searching by productcode (sku) not so easy after upgrade???

ok so before i could do
$search_query = "($sql_tbl[products].product like '%$substring%' or $sql_tbl[products].descr like '%$substring%'or $sql_tbl[products].productcode like '%$substring%') and $sql_tbl[categories].category like '$search_category%' and $sql_tbl[products].forsale='Y' $price_condition ".$sort_by_price;

now if i attempt that it doesn't return any results using the sku #
(version 3.3.1) anyone sucessfully able to search by sku/productcode in this version (or others?)

thanks for your time, wayne
Reply With Quote