Hello.
I have some errors when acces
http://mallromania.ro/newproducts.php
INVALID SQL: 0 :
SQL QUERY FAILURE: SELECT COUNT(xcart_products.productid) FROM xcart_products, xcart_categories, xcart_products_categories, xcart_pricing WHERE xcart_products.productid=xcart_products_categories .productid AND xcart_products_categories.categoryid=xcart_categor ies.categoryid AND xcart_products.productid=xcart_pricing.productid AND xcart_pricing.quantity=1 AND (xcart_pricing.membership='' OR xcart_pricing.membership='') AND (xcart_categories.membership='' OR xcart_categories.membership='') AND xcart_products.forsale='Y' AND xcart_products.avail>0 AND xcart_pricing.variantid = 0AND xcart_products.avail > 0 AND add_date > 1143817094 AND add_date < 1144421894 GROUP BY xcart_products.productid
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mallroma/public_html/include/func.php on line 102
I added latest code and corection for it but still have this error. Also, no products are show when select 24 hours, 3 days etc
Thanks