******************************************************************************** there are four different files on this page. they will each be seperated by a large block of text like this one... ******************************************************************************** Pizza Order Form [reset this form]
Name:
Address:
City, State, Zip:
Phone:
Quantity:
Pizza Size:
Small 10" - $8.99
Medium 14" - $12.99
Large 16" - $15.99
X-Large 36" - $35.99
Toppings:
Extra Cheese
Pepperoni
Ham
Peppers
Pineapple
Notes:
Opt In - Mailing List:
(checked means we'll get you on the cupon list)
 
*************************************************************************************** below this is page 2 or the action page... ***************************************************************************************

Missing a customer name. At least 3 characters are required.

Missing a customer address. At least 3 characters are required.

Missing a city. At least 3 characters are required.

Missing a state. Choose from the list provided.

Missing a zip. At least 5 characters are required. Ex: 84333

Missing a valid order quantity. Please choose from the list provided.

 INSERT INTO orders_table (customer_address, customer_city, customer_name, customer_notes, customer_phone, customer_state, customer_zip, opt_in, order_quantity, pizza_size, pizza_toppings) VALUES('#Trim(FORM.customer_address)#', '#Trim(FORM.customer_city)#', '#Trim(FORM.customer_name)#', '#Trim(FORM.customer_notes)#', '#Trim(FORM.customer_phone)#', '#Trim(FORM.customer_state)#', '#Trim(FORM.customer_zip)#', #FORM.opt_in#, #FORM.order_quantity#, '#Trim(FORM.pizza_size)#', '#Trim(FORM.pizza_toppings)#') Untitled Document Pizza Order
Customer Name: #FORM.customer_name#
Number: #FORM.order_quantity#
Pizza Size: #FORM.pizza_size#
Type: #FORM.pizza_toppings#
*************************************************************************************** below this is page 3 or the orders homepage... *************************************************************************************** SELECT order_id, customer_name, customer_phone, pizza_size FROM orders_table WHERE order_id > 1 ORDER BY order_id DESC Orders Homepage #qryGetAllOrders.order_id# - #qryGetAllOrders.customer_name# - #qryGetAllOrders.customer_phone# - Size=#qryGetAllOrders.pizza_size#
*************************************************************************************** below this is page 4 or the order details page... ***************************************************************************************

Missing a valid order id number. Unable to proceed.

Sorry, the order id number must be numeric and greater than 0.

 SELECT * FROM orders_table WHERE order_id = #Trim(URL.id)# Order Details

Order ## #URL.id#

Name: #qryGetOrderDetails.customer_name#
Address: #qryGetOrderDetails.customer_address#
City, State, Zip: #qryGetOrderDetails.customer_city#, #qryGetOrderDetails.customer_state# #qryGetOrderDetails.customer_zip#