I added 2 new columns to my orders table via phpmyadmin, order_mill_grains and order_bag_separately. During checkout, I have added 2 pulldown menus on the shipping information page, record into these new table columns. This is all working, meaning when I look at the orders table in phpmyadmin the selection from the pull down menus are showing in the new columns.

My question, how to I call this value. I want to do a couple things.
(1) I want to be able to show the customer their choices on the checkout confirmation page. I tried modifying tpl_ checkout_confirmation_default, but had no luck.

(2) I also want to be able to see these values when I look at the order in Zen Cart admin.

(3) Lastly, I would like to be able to include these values in the order confirmation email to the customer.

Any help here is greatly appreciated.

Thanks,
Jeremiah