$sql="SELECT haironline_pic.id,haironline_pic.title,haironline_pic.imageurl,haironline_pic.simageurl,haironline_pic.frontface,haironline_pic.prodid FROM haironline_pic inner join haircollect on haironline_pic.id=haircollect.hairstyleid where haircollect.merberid=$mid order by haircollect.id desc LIMIT $p->firstRow,$p->listRows ";好了、、
我想读取出用户收藏的图片的详细信息,并按haircollect中的id(自增长字段)排序
$sql="SELECT haironline_pic.id,haironline_pic.title,haironline_pic.imageurl,haironline_pic.simageurl,haironline_pic.frontface,haironline_pic.prodid FROM haironline_pic inner join haircollect on haironline_pic.id=haircollect.hairstyleid where haircollect.merberid=$mid order by haircollect.id desc LIMIT $p->firstRow,$p->listRows ";好了、、