You have:
code: WHERE (shops_products.product LIKE '%35mm%') AND (shops_products.sid = shops.sid)
OR (shops_products.product LIKE '%photography%') AND (shops_products.sid = shops.sid)
You want:
code: WHERE (shops_products.sid = shops.sid)
AND ((shops_products.product LIKE '%35mm%') OR (shops_products.product LIKE '%photography%'))
(unless I'm missing something?)
|