SELECT email, id
FROM cgi_users
WHERE email = '#emailName#'
INSERT INTO cgi_item (`userid`,`infuse_sub`)
VALUES('#userid#', '#form.request#')
INSERT INTO cgi_users (`email`,`FirstName`,`LastName`,`Address`,`Address2`,`City`,`State`,`Country`,`ZipCode`)
VALUES('#emailName#', '#form.FirstName#', '#form.LastName#', '#form.Address#', '#form.Address2#', '#form.City#', '#form.State#', '#form.Country#', '#form.ZipCode#')
SELECT email, id
FROM cgi_users
WHERE email = '#emailName#'
INSERT INTO cgi_item (`userid`,`infuse_sub`)
VALUES('#userid#', '#form.request#')
Name: #form.FirstName# #form.LastName#
Street: #form.Address#
Apt: #form.Address2#
City: #form.City#
State: #form.State#
Postal/Zip Code: #form.ZipCode#
Country: #form.Country#
Untitled
Thank You