<% OpenDB() 'response.redirect("maintenance.asp") If Session("custID") ="" then response.redirect "cart_empty.asp" End If subtotal = 0 counter = 0 sql = "Select cart.*, productname, productprice from cart left join products on cart.itemid = products.productid where custID = " & Session("custID") rs.open sql, , , adopenstatic %> Bonds of London : Your Order

Your Current Order

<% do while not rs.eof counter = counter + 1 %> "> <% subtotal = subtotal + (rs("itemqty") * rs("productprice")) rs.movenext loop if subtotal < 49.99 Then delcharge = 3.950 elseif subtotal > 49.99 AND subtotal < 99.99 Then delcharge = 6.95 elseif subtotal > 99.99 and subtotal < 499.99 Then delcharge = 8.95 elseif subtotal > 500 Then delcharge = 10.95 End if vatcost = subtotal * 0.0 newsubtotal = vatcost + subtotal If subtotal = 0 then delcharge = 0 End If tot = subtotal + delcharge %>
Product Quantity Price Remove Update
<%=rs("productname") %> " size="3" /> <%=formatcurrency(rs("productprice"),2) %> ">Remove From Basket
Subtotal Delivery Charge Total
<%=formatcurrency(subtotal,2) %> <%=formatcurrency(delcharge,2) %> <%=formatcurrency(tot,2) %>

All prices include UK VAT at 20%

Back