<% Upper_Patch "product" dim prod_id dim db connection set rs13=server.createobject("adodb.recordset") s2="select * from directory_inquiry where Supplier_id="&session("myid")&" " rs13.open s2 , db, 3 set rs12=server.createobject("adodb.recordset") s2="select * from product_inquiry where Supplier_id="&session("myid")&" " rs12.open s2 , db, 3 set rs=server.createobject("adodb.recordset") set rs1=server.createobject("adodb.recordset") set rs2=server.createobject("adodb.recordset") prod_id = request.querystring("prod_id") rs.open "select * from product where prod_id="&request.querystring("prod_id"),db,3 response.write "
" response.write "Home >> " response.write "Update Your Products :
" response.write "
" response.write "" response.write "" response.write "" response.write "" response.write "" response.write "" response.write "

" response.write "  Inbox ("&rs13.recordcount&")
" response.write "  View Product Inquiry ("&rs12.recordcount&")
" response.write "  Update Listing
" response.write "  Update Products
" response.write "  Add More Products
" response.write "  Change Password
" response.write "  Logout
" response.write "		" response.write "
" response.write ""&session("company_name")&"
" response.write "

Update your product details:" response.write "
(Fields marked with * are mandatory)" response.write "

" response.write "" response.write "" response.write "" response.write "" response.write "" response.write "" response.write "" response.write "" response.write "" response.write "" response.write "" response.write "" rs1.open "select cat_id, category from category where cat_id in(select cat_id from cat where supplier_id="&rs("supplier_id")&")", db, 3 response.write "" rs1.close rs2.open "select * from material", db, 3 response.write "" response.write "" response.write "" response.write "" response.write "" response.write"
Product Name :" response.write "*
Description :" response.write "*
Key Specification :" response.write "*
Price :
Delivery :
Category :*
Material :*
  
" rs.close set rs=nothing db.close set db=nothing %>
<% response.write "
" Bottom_Patch %>