Thanks for the extremely fast answer! I am not very good at this. I tried this, which is eliminating the membership-restricted products, but the search is no longer dynamic:
Code:
$sql = "
SELECT p.`productid`, p.`forsale`, l.`product`, i.`image_path`, m.`membershipid`, concat('product.php?productid=',p.`productid`) AS link FROM (`$sql_tbl[products]` p
INNER JOIN `$sql_tbl[products_lng_current]` l ON (p.`productid` = l.`productid`)
LEFT JOIN `$sql_tbl[images_T]` i ON p.`productid` = i.`id`)
INNER JOIN `$sql_tbl[xcart_products_memberships]` m ON p.`productid` = m.`productid`)
WHERE p.`forsale` != 'N' AND m.`membershipid` != '' AND product like '%".$_GET["q"]."%'
";
Do you have any suggestions?