Yes, I kind of fixed it with this...
Quote:
|
SELECT pr.productid, pr.product, mem.membershipid FROM $sql_tbl[products_categories] AS cat, $sql_tbl[products_lng_en] AS pr LEFT JOIN $sql_tbl[product_memberships] AS mem ON mem.productid = pr.productid WHERE cat.categoryid = '$product_info[categoryid]' AND pr.productid = cat.productid ORDER BY pr.product
|
Still need to join 'product.forsale' somehow...