$list = "SELECT * FROM categories,products,form_products
WHERE products.category_id=categories.category_id AND products.category_id='$cat' AND products.$p_type='1'
AND products.product_id NOT IN (SELECT form_product FROM form_products WHERE form_id='$_POST[id]') ORDER BY products.product_id ASC";
Then a while loop to show the products. Without the sub query it works fine, just can't get the subquery to work. Any ideas?
Last edited by rsmarsha on Wed Feb 22, 2006 3:03 am, edited 1 time in total.
$list = "SELECT * FROM categories,products LEFT JOIN form_products ON products.product_id = form_products.form_product
WHERE products.category_id=categories.category_id AND products.category_id='$cat' AND products.$p_type='1'
ORDER BY products.product_id ASC";