sql

 $sql = ‘select max(price.price) as max_price,min(price.price) as min_price, c.id,c.pid,c.name,c.pic,p.title,p.id as pro_id,p.title
        from xy_product_cate as c
        left  join xy_product as p on  c.id = p.cid
        left  join xy_price as  price on price.pid = p.id
        where c.pid in (‘.$idsStr.‘)  and c.status=0
        group by c.id‘;（这里要用总的）

sql

原文：http://www.cnblogs.com/allen817/p/6231740.html