select typeid,typename from producttype where typeid=#typeid# select proid,proname,prodesc,price,img,protime,size,typeid from product