Author Topic: Extra Information on Confirmation Email  (Read 5407 times)

hrtrulz

  • Beginner
  • *
  • Posts: 2
Extra Information on Confirmation Email
« on: July 03, 2008, 05:30:45 am »
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

  • Beginner
  • *
  • Posts: 2
Re: Extra Information on Confirmation Email
« Reply #1 on: July 04, 2008, 12:46:45 pm »
I found my error. I was saving this info to the db after the email was sent. Fix this now it works.