Like a number of previous posters I have been attempting to solve the problem of producing a viable way of getting event tickets to my customers.

Having played around with a number of options I have come back to the confirmation email as the most effective way of doing things - creating the ticket(s) on the bottom of the email for the customer to print. (We are a small enough venue - 150 seats - to not have to worry too much about duplication - we would spot it in the post event ticket count and quickly identify duplicates, together with the transgressor, as their name would be on the stub)

Anyway, I've modified the information/design of the confirmation email - Email_template_checkout - to my satisfaction, with the tickets listed at the bottom of the email.

I want to do two final tweaks and would be most grateful if anyone could help me please with the SQL. in the footer section shown below

1. I want to force a printer page break above the point that the list of sales begins. (ie where there is currently a dotted line saying 'tear off' )

2. At present, the email itemises the tickets for different events on a separate line which is good. HOWEVER, what I'd really like to do is where someone has ordered x tickets is to have a little loop which prints that line/ticket x times. The number of tickets purchased is contained (I think) as a part of $products_detail.

Many thanks in advance.

Tony


<!-- Footer Section -->
<div class="footer">
<div class="copyright">
<p>$EXTRA_INFO</p>
<p>
<span class="style11"><span class="style12">THIS IS YOUR ON-LINE TICKET CONFIRMATION - </span>
<p class="product-details style21"><span class="style20">YOU MAY NOW BRING WITH YOU TO AVOID QUEUING AT THE BOX OFFICE -</span><span class="style19"> </span>
</p>
</div>
</div>
</div>

</div>
<em>---------------------------------------- TEAR OFF --------------------------------------------------------</em>
<p class="product-details"><span class="style11"><img src="email/logo.jpg" width="855" height="174"></span></p>
<p class="product-details"><span class="style11">$EMAIL_FIRST_NAME $EMAIL_LAST_NAME, </span><span class="content-line"><span class="style11">$INTRO_ORDER_NUM_TITLE $INTRO_ORDER_NUMBER</span></span></p>
<p class="style12"><span class="style16">$ORDER_COMMENTS</span></p>
<div class="content-line-title">
<p>$PRODUCTS_DETAIL</p>
<p><span class="order-detail-area">$ORDER_TOTALS</span></p>
</div>
</body>
</html>