Notice: Undefined index: id in /var/www/goldend1/public_html/crossbow.php on line 76
/var/www/goldend1/public_html/crossbow.php 78
1064 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 p.id = p2c.product_id' at line 5

SELECT min(p.price) as min_price,
			   max(p.price) as max_price
          FROM product2category p2c, products p
          WHERE p2c.category_id = 
          AND p.id = p2c.product_id