update members set first_name = '#form.firstname#', last_name = '#form.lastname#', job_title = '#form.title#', company = '#form.company#', address = '#form.address#', city = '#form.city#', state = '#form.state#', zip = '#form.zip#', phone = '#form.phone#', fax = '#form.fax#', email = '#form.email#', url = '#form.url#', password = '#form.password#', username = '#form.username#' where memberid = #session.userid# Hello, You have recently updated your profile on HansenGuns.com site! Here is your login information. Username: #form.username# Password: #form.password# If you have any problems with logging in or you did not recently update your profile please contact me immediately. Thank You, HansenGuns.com select first_name, last_name, job_title, company, address, city, state, zip, email, url, phone, fax, username, password from members where memberid = #session.userid#
#DateFormat("#Now()#", "dddd mmmm dd, yyyy")#  


Username:*   (use this to log in)
Password:*
   Confirm:*
Although your password is not shown you may change it.
The changes will be emailed to the address provided.
First Name:*
   Last Name:*
Title:
   Company:
Address:
   City:
State:
   Zip:
Email:*
   URL:
Phone:
   Fax:
Remember me: checked>