SELECT items.id, items.name, items_brands.brand_id, items_categories.cat_id FROM items LEFT JOIN items_brands
ON items.id=items_brands.item_id LEFT JOIN items_categories ON items.id=items_categories.item_id WHERE items.id>0 AND items.hidden=0AND items.sex = '' GROUP BY items.id ORDER BY items_brands.position ASC
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'items.sex = '' GROUP BY items.id ORDER BY items_brands.position ASC' at line 2 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/corporat/public_html/classes/class.sql.php on line 53 SELECT items.id, items.name, items_brands.brand_id, items_categories.cat_id FROM items LEFT JOIN items_brands
ON items.id=items_brands.item_id LEFT JOIN items_categories ON items.id=items_categories.item_id WHERE items.id>0 AND items.hidden=0AND items.sex = '' GROUP BY items.id ORDER BY items_brands.position ASC LIMIT 0,12
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'items.sex = '' GROUP BY items.id ORDER BY items_brands.position ASC LIMIT 0,12' at line 2