I have added extra fields to the checkout. I am try to add these details to the Confirmation Email and i can't get them to add.
I have added these details to the the site's display and print pages.
I have 4 fields added to the page. There are 'event_name', 'event_venue', 'event_stand_no' and 'event_stand_name'. These have been added to a new table (jos_vm_order_event).
I have added the folowing code to the 'confirmation_email.tpl.php' but the fields are blank in the email.
<?php
$dbEI = new ps_DB;
$qEI = "SELECT event_name, event_venue, event_stand_no, event_stand_name FROM #__{vm}_order_event WHERE order_id =".$order_id;
$dbEI->query($qEI);
$dbEI->next_record();
?>
<tr class="Stil1">
<td>Event Name:</td><td><?php echo $dbEI->f("event_name"); ?></td>
</tr>
<tr class="Stil1">
<td>Venue:</td><td><?php echo $dbEI->f("event_venue"); ?></td>
</tr>
<tr class="Stil1">
<td>Stand No.:</td><td><?php echo $dbEI->f("event_stand_no"); ?></td>
</tr>
<tr class="Stil1">
<td>Stand Name:</td><td><?php echo $dbEI->f("event_stand_name"); ?></td>
</tr>