update customers set CompName='#CompName#',FirstName='#FirstName#',LastName='#LastName#',BillAddress='#BillAddress#',BillCity='#BillCity#',BillState='#BillState#',BillCountry='#BillCountry#',BillZip='#BillZip#',Phone='#Phone#',Email='#Email#', ccname='#ccname#',ccnumber='#ccnumber#',ccexpmo='#ccexpmo#',ccexpyr='#ccexpyr#',cctype='#cctype#',shipfirstName='#shipfirstName#',shipLastName='#shipLastName#',shipAddress='#shipAddress#',shipCity='#shipCity#',shipState='#shipState#',shipCountry='#shipCountry#',shipZip='#shipZip#' ,username='#trim(username)#',password='#password#' where customerID=#get_key.customerID# select * from customers where customerID=#get_key.customerID# select * from countries select * from states

Welcome, #firstname# #lastname#

Your account information has been updated.

Your current account information is detailed below. Please review for accuracy, make necessary updates by typing over the current information and selecting Update at the bottom of this screen.

Billing Information


Company Name:
First Name:
Last Name:
Address:
City:
State: If USA
Province: If other countries
Zip/Postal Code:
Country:
Phone:
Email:

Card Type:	checked> Visa checked> MasterCard checked> American Express checked> Discover
Card Number:
Exp. Month:	Exp. Year:
Card Holder Name:

Shipping Address
First Name:
Last Name:
Address:
City:
State: If USA
Province: If other countries
Zip/Postal Code:
Country:
Security Information
Username (email):
Password:
Re-type Password: