select typeid,typename from producttype where typeid=#typeid#



  select proid,proname,prodesc,price,img,protime,size,typeid from product