Notice: Undefined variable: materialid in /home/baileystreetscene.co.uk/public_html/product-listing.php on line 51

Fatal error: Uncaught exception 'Exception' with message 'SELECT SQL_CALC_FOUND_ROWS p.*, s.supname AS manufacturer, c.catname AS category FROM biss_prod AS p LEFT JOIN biss_supplier AS s ON s.Supplierid = p.supplierid JOIN biss_category AS c ON c.Catid = p.catid WHERE p.activated=1 AND p.materialid = AND c.Catid = 2 ORDER BY FIELD(prodbaseprice, '*', '0'), prodbaseprice ASC LIMIT 0, 15 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 'AND c.Catid = 2 ORDER BY FIELD(prodbaseprice, '*', '0'), prodbaseprice ASC LIMI' at line 1' in /home/baileystreetscene.co.uk/public_html/includes/class.collection.php:133 Stack trace: #0 /home/baileystreetscene.co.uk/public_html/product-listing.php(58): collection->customLoad('SELECT p.*, s.s...', Array) #1 {main} thrown in /home/baileystreetscene.co.uk/public_html/includes/class.collection.php on line 133