Hmm.. it looks right, but still got an error:
test is the first word, and test2 is the second
Quote:
INVALID SQL: 1064 : You have an error in your SQL syntax near INVALID SQL: 1064 : You have an error in your SQL syntax near '(xcart_products.product like '%test%' or xcart_products.product like '%test1%') ' at line 1
SQL QUERY FAILURE: select count(*) from xcart_products, xcart_pricing, xcart_categories where xcart_pricing.productid=xcart_products.productid and xcart_pricing.quantity=1 and xcart_products.categoryid=xcart_categories.categor yid AND (xcart_categories.membership='' OR xcart_categories.membership='') and (xcart_pricing.membership='' or xcart_pricing.membership='') and (xcart_products.product like '%test test1%' or xcart_products.descr like '%test test1%') AND 1 and xcart_products.forsale='Y' and xcart_categories.avail='Y' (xcart_products.product like '%test%' or xcart_products.product like '%test1%') group by xcart_products.productid
|
Maybe the [i] needs to be added to the %$substring[i]% like the example?