Error in query SELECT -1 AS stock_status, p.*,IF (sale_price >0,IF (sale_until >= CURDATE(),sale_price,price),price) AS curprice,DATE_ADD(posted_on, INTERVAL 31 DAY) as posted_on FROM products p WHERE DATE_ADD(p.posted_on, INTERVAL DAY) >= CURDATE() AND p.inactive<>1 and (p.price<>0 or p.sr_price<>0) ORDER BY posted_on,prod_id DESC,sort_priority DESC LIMIT 0,2
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') >= CURDATE() AND p.inactive<>1 and (p.price<>0 or p.sr_price<>0) ' at line 3Error in query SELECT COUNT(*) FROM products WHERE products.featured_item=1 AND products.inactive<>1 and (products.price<>0 or products.sr_price<>0)
Table 'prcs_ticket_system.products' doesn't exist