SELECT * FROM CartItems WHERE CartIDReference = #USR_cartid# ORDER BY CartItemID

Thank you. The following is a final preview of your order information. After you review the order information, please click the button at the bottom of the page to complete your order.

select * from items where itemcode='#itemcode#' select * from StateTax where state ='#USR_ShipState#'
Item Code Item Name
Qty.
Unit Price
Total Price
#get_desc.itemcode#
#get_desc.itemname# (#get_desc.itemCode#)
Size: #itemsize#    #itemcolor#
#quantity#
#dollarFormat(lockPrice)#
#dollarFOrmat(totalprice)#
Total: 
#dollarFormat(USR_orderTotal)#
Tax: 
#dollarFormat(USR_tax)#
Shipping: 
#dollarFormat(USR_sh)#
Grand Total: 
#dollarFormat(USR_grandTotal)#

select * from ship_#get_softwareID.shipping# where sh1=#USR_sh#
Shipping Address
#USR_shipFirstname# #USR_shipLastname#
#USR_shipAddress#
#USR_shipCity# #USR_shipState#, #USR_shipcountry# #USR_shipZip#
#USR_ShipPhone#

Shipping Method/Cost
#dollarFormat(USR_sh)# - #get_shipping.description# #dollarFOrmat(USR_sh)#