Admin Registration

SELECT id FROM vendor ORDER By id SELECT boothid, booth, member, non_member FROM booth WHERE booth = '#y#' INSERT INTO vendor (id, company, firstname, lastname, position, npo, address1, address2, city, zip, phone, fax, email, booth, electric, basictable, addtable30, addtable42, barstool, barstooladd, amount, ad) VALUES ('#idnum#', '#companyIn#', '#firstnameIn#', '#lastnameIn#', '#positionIn#', '#form.npo#', '#address1In#', '#address2In#', '#cityIn#', '#zipIn#', '#phoneIn#', '#faxIn#', '#emailIn#', '#form.boothlist#', '#form.electric#', '#basictable#', '#addtable30#', '#addtable42#', '#barstool#', '#barstooladd#', '#boothtotal#', '#form.ad#') UPDATE booth SET reservedid = '#idnum#' WHERE booth = '#y#'

RO/RO Website Registration Confirmation

Vendor ID	#id#
Name:	#firstname# #lastname#
Company Name:	#company#
Address:	#address1#, #address2#
City:	#city#
State:	#state#
Zip:	#zip#
E-mail:	#email#
Reservation Amt:	*$ #amount#.00*
Member	#member#
Booth Number	#booth#
Electric	#electric#
Basic table	#basictable#
Upgrade table 30"	#addtable30#
Upgrade table 42"	#addtable42#
Upgrade Barstool	#barstool#
Additional Barstool	#barstooladd#
Advertising	$ #ad#.00

Transaction Num: Approval Code: Approval Customer ID	#trans_id# #approve_code# #approve# #cust_id#
The above information should be kept for your records.

Home

SELECT * FROM vendor WHERE id = '#id#'

Booth Registration - Payment Information



Vendor Name:	#company#
Vendor ID	#ID#
Registration Total:	$ #amount#.00


This registration has been accepted.
To process another, Please click here