Order Summary start over <%if session("order_id") <> "" then%> Customer: <%=session("cust_name")%> Store: <%=replace(session("store_name"),"Freebirds @ ","")%> Order #: <%=session("order_id")%>w3 <% total = 0 set rs = server.createobject("adodb.recordset") sql = "SELECT tbl_oline.qty, tbl_oline.price, tbl_oline.label, tbl_oline.id, " & _ "tbl_product.name AS product_name, tbl_product.type, " & _ "tbl_product2.name AS product_name2 " & _ "FROM tbl_oline " & _ "LEFT JOIN tbl_product ON tbl_oline.product_id=tbl_product.id " & _ "LEFT JOIN tbl_oline AS tbl_oline2 ON tbl_oline.id=tbl_oline2.seq_id " & _ "LEFT JOIN tbl_product AS tbl_product2 ON tbl_oline2.product_id=tbl_product2.id " & _ "WHERE tbl_oline.order_id=" & session("order_id") & " " & _ "AND tbl_oline.seq_id=-1" rs.open sql, cnn, 1, 3 do until rs.eof total = total + (rs("qty") * rs("price")) page = rs("type") if rs("product_name") = "Tortillas" then page = "tortilla" if left(rs("product_name"),5) = "Chips" or left(rs("product_name"),5) = "2 oun" then page = "chips" product_name = rs("product_name") & "" if rs("product_name2") & "" <> "" and product_name <> rs("product_name2") & "" then product_name = replace(product_name,"Tacos","") & " / " & rs("product_name2") end if if left(rs("label"),1)="L" then product_name = "Little Monster " & product_name %> <% rs.movenext loop rs.close set rs = nothing %> QTY - DESCRIPTION PRICE <%=rs("qty")%> - "><%=product_name%> <%if rs("label")<>"" then response.write "     (" & rs("label") & ")"%> <%=formatcurrency(rs("qty") * rs("price"),2)%> Order Total:  <%=formatcurrency(total,2)%> <%if instr(request("script_name"),"menu.asp") > 0 then%> Please place your drink order at the store when picking up your order. <%end if%> <%else%> Your order summary will appear here once you've started to place your order. <%end if%>