Extra Information on Confirmation Email

[hrtrulz]

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.

Code: [Select]

<?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>


[hrtrulz]

I found my error. I was saving this info to the db after the email was sent. Fix this now it works.