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
|