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

Thank you, #firstname# #lastname#.
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 ='#billstate#'
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(orderTotal)#
Tax: 
#dollarFormat(tax)#
Shipping: 
#dollarFormat(sh)#
Grand Total: 
#dollarFormat(grandTotal)#

select ccnumber from customers where customerID=#get_key.customerID# select * from ship_#get_softwareID.shipping# where sh1=#sh#
Billing Address Shipping Address
#firstname# #lastname#
#BillAddress#
#billcity# #billstate#, #billcountry# #billZip#

#firstName# #lastName#
#BillAddress#
#billCity# #billState#, #billcountry# #billZip# #shipFirstname# #shipLastname#
#shipAddress#
#shipCity# #shipState#, #shipcountry# #shipZip# #ThisFirstname# #ThisLastname#
#ThisAddress#
#ThisCity# #ThisState#, #thisCountry# #ThisZip#


Credit Card Number Credit Card Expiration
#Left(ccnumber,2)#**********#Right(ccnumber,4)#

#ccexpmo#/#right(ccexpyr,2)#

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