你看下教程吧

http://bbs.kesion.com/dispbbs.asp?boardid=42&Id=42054

语句:

select id,title,price_market,price_member,ProSpecificat,photourl from ks_product where verific=1 order by id desc

循环体,请自写