<% if session("username")="" then Response.Redirect("login.asp") end if %> Mucho Items
 
 

  <%if request("flag")=1 then%> Your dont have enough items to sell <%end if%>

<% 'set rsitem = server.CreateObject("ADODB.RecordSet") 'rsitem.open "select petitemid from petitemtable where userpetid = " & request("petid") & " and itemid = " & request("itemid"),conn set rs = server.CreateObject("ADODB.RecordSet") rs.open "select itemname from itemtable where itemid = " & request("itemid") , conn set rsq = server.CreateObject("ADODB.RecordSet") rsq.open "select quantity,petitemid from petitemtable where userpetid = " & request("petid") & " and itemid = " & request("itemid"),conn %>
  Mucho Delete Items
Item Name Available Quantity Quantity
<%=rs("itemname")%> <%=rsq("quantity")%> "> ">