View Cart
Sign up for the specials and events     
 
STYLE SEARCH

error in sql query
select d.name, d.id  from  tbl_products p, tbl_prod_cat pc, tbl_designer d where pc.pid=p.id and pc.cid=25 and p.status='y' and d.id=p.designer_id group by p.designer_id order by d.designer_order, pc.p_order 
.mysql error : Expression #2 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'all4brid_all4bride.pc.p_order' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by