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.stock>0 AND items.hidden=0AND items.sex = 'm' 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 = 'm' 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/concept/public_html/classes/class.sql.php on line 62
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.stock>0 AND items.hidden=0AND items.sex = 'm' GROUP BY items.id ORDER BY items_brands.position ASC LIMIT 0,15
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 = 'm' GROUP BY items.id ORDER BY items_brands.position ASC LIMIT 0,15' at line 2
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/concept/public_html/classes/class.sql.php on line 62
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/concept/public_html/classes/class.sql.php on line 62
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 = 'm' 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/concept/public_html/classes/class.sql.php on line 62
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.stock>0 AND items.hidden=0AND items.sex = 'm' GROUP BY items.id ORDER BY items_brands.position ASC LIMIT 0,15
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 = 'm' GROUP BY items.id ORDER BY items_brands.position ASC LIMIT 0,15' at line 2
View All |
Change Order :
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/concept/public_html/classes/class.sql.php on line 62
There are currently no products in this category.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/concept/public_html/classes/class.sql.php on line 62
