<cfsavecontent variable="headercontent">
<title>CG Order</title>
</cfsavecontent>

<Cfinclude template="/header.cfm">
<cfinclude template="/rossavings.cfm">

    <main>
	            <div class="white_bg" >
            <div class="container margin_60" style="max-width: 600px;">
                <div class="main_title">
                    <h2>Order Confirmed</span></h2>
                </div>
                
                
                <Cfloop from="1" to="#url.totalq#" index="ThisRow">
                    

                   <Cfquery name=addphoto datasource="cg22">

INSERT INTO  	liveeventguests (orderid,name,email,phone,facebook,instagram

)

VALUES	(#url.order#,
'#Evaluate("form.guestname" & ThisRow)#',

'#Evaluate("form.guestemail" & ThisRow)#',
'#Evaluate("form.guestphone" & ThisRow)#','',''
)

		</cfquery>

                    
                </Cfloop>

<Cfquery name="getorder" datasource="#ds#">
select firstname,email from liveeventorder  where id = #url.order#
</cfquery>
<CFMAIL
TO="#getorder.email#"
SUBJECT="WIT Ticket Guest Confirmation"
 FROM="Women in Tourism <[email protected]>"
SERVER="127.0.0.1"
type="html"
>
    <img src="https://www.cityguideny.com/WIT_websitebanner2.png" style="max-width:600px;width:100%">
<p>
    Hi #getorder.firstname#,
    
Your guests are confirmed:

<p>
	   <Cfloop from="1" to="#url.totalq#" index="ThisRow">
      #Evaluate("form.guestname" & ThisRow)#
      <p>

                    
                </Cfloop>


</cfmail>

<cfoutput>
    <Cfquery name="getcoupon" datasource="#ds#">
select *  from liveeventpackages
where id = #url.package#

</cfquery>

#getcoupon.PACKATECONFIRMATIONPAGE#
</cfoutput>

    </div>


    <!-- //////////////////////////////////
//////////////END PAGE CONTENT/////////
////////////////////////////////////-->
                           </div>
        </div>

                </div>
            </div>
        </div>
    </main>

    <cfinclude template="/footer.cfm">