Thanks Alex!
It works like magic
The code looks like this right now (there is no membership):
Code:
if ($cat != "")
$xcat = $cat;
else
$xcat = $product_info["categoryid"];
$mem_list = func_query("SELECT pr.productid, pr.product FROM $sql_tbl[products_categories] AS cat, $sql_tbl[products] AS pr WHERE cat.categoryid = '$xcat' AND pr.productid = cat.productid AND pr.forsale='Y' ORDER BY pr.product");
$list = array();
Thanks!