******************************************************************************** there are three 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... *************************************************************************************** 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('#FORM.customer_address#', '#FORM.customer_city#', '#FORM.customer_name#', '#FORM.customer_notes#', '#FORM.customer_phone#', '#FORM.customer_state#', '#FORM.customer_zip#', #FORM.opt_in#, #FORM.order_quantity#, '#FORM.pizza_size#', '#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 some SQL if you want to make the orders_table for the pizza orders... copy and paste the code below into your SQL editor within the database you want and a new table will be created... you can then use the two pages above this to populate the table from a web form. ************************************************************************************************ CREATE TABLE `orders_table` ( `order_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `customer_name` varchar(100) DEFAULT NULL, `customer_address` varchar(100) DEFAULT NULL, `customer_city` varchar(50) DEFAULT NULL, `customer_state` varchar(4) DEFAULT NULL, `customer_zip` varchar(15) DEFAULT NULL, `customer_phone` varchar(25) DEFAULT NULL, `order_quantity` int(11) unsigned NOT NULL DEFAULT '0', `pizza_size` varchar(10) DEFAULT NULL, `pizza_toppings` varchar(255) DEFAULT NULL, `customer_notes` varchar(255) DEFAULT NULL, `opt_in` tinyint(1) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`order_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;