Hello,
I believe something is wrong w/ my code here and am hoping it's easy for somebody with more knowledge to spot.

Issue: I'm adding four custom fields to the "Extra Info" or "Office Use Only" section of the Order Confirmation email. Only the last field ever shows in the email regardless of what field it is. All fields work correctly and I'm seeing them in the admin panel where I've also added them under Customer details. I'm using this thread for reference on how to add a field to the email - http://www.zen-cart.com/forum/showth...t=74590&page=3

My code looks like this:

Code:
//MY NEW CODE STARTS HERE
    global $db;
    $sql = "select customers_partner from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$_SESSION['customer_id'] . "'";
    $result = $db->Execute($sql); 
        global $db;   
    $sql = "select customers_drmidwife from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$_SESSION['customer_id'] . "'";
    $result = $db->Execute($sql); 
    global $db;       
    $sql = "select customers_duedate from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$_SESSION['customer_id'] . "'";
    $result = $db->Execute($sql);     
    global $db;
    $sql = "select customers_delivering from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$_SESSION['customer_id'] . "'";           
    $result = $db->Execute($sql); 
//MY NEW CODE ENDS HERE

    // generate footer details for "also-send-to" emails
    $extra_info=array();
    $extra_info['TEXT'] =
      OFFICE_USE . "\t" . "\n" .
      OFFICE_FROM . "\t" . $from . "\n" .
      OFFICE_EMAIL. "\t" . $email_from . "\n" .
      (trim($login) !='' ? OFFICE_LOGIN_NAME . "\t" . $login . "\n"  : '') .
      (trim($login_email) !='' ? OFFICE_LOGIN_EMAIL . "\t" . $login_email . "\n"  : '') .
      ($login_phone !='' ? OFFICE_LOGIN_PHONE . "\t" . $login_phone . "\n" : '') .
      ($login_fax !='' ? OFFICE_LOGIN_FAX . "\t" . $login_fax . "\n" : '') .
//MY NEW CODE STARTS HERE - BUT ONLY THE LAST FIELD SHOWS UP
      'Partner: ' . "\t" . $result->fields['customers_partner'] . "\n" .     
      'Due Date: ' . "\t" . $result->fields['customers_duedate'] . "\n" .     
      'Dr or Midwife: ' . "\t" . $result->fields['customers_drmidwife'] . "\n" .     
      'Delivery Location: ' . "\t" . $result->fields['customers_delivering'] . "\n" .  
//MY NEW CODE ENDS HERE        
      OFFICE_IP_ADDRESS . "\t" . $_SESSION['customers_ip_address'] . ' - ' . $_SERVER['REMOTE_ADDR'] . "\n" .
      OFFICE_HOST_ADDRESS . "\t" . $email_host_address . "\n" .
      OFFICE_DATE_TIME . "\t" . date("D M j Y G:i:s T") . "\n\n";

    $extra_info['HTML'] = '<table class="extra-info">' .
      '<tr><td class="extra-info-bold" colspan="2">' . OFFICE_USE . '</td></tr>' .
      '<tr><td class="extra-info-bold">' . OFFICE_FROM . '</td><td>' . $from . '</td></tr>' .
      '<tr><td class="extra-info-bold">' . OFFICE_EMAIL. '</td><td>' . $email_from . '</td></tr>' .
      ($login !='' ? '<tr><td class="extra-info-bold">' . OFFICE_LOGIN_NAME . '</td><td>' . $login . '</td></tr>' : '') .
      ($login_email !='' ? '<tr><td class="extra-info-bold">' . OFFICE_LOGIN_EMAIL . '</td><td>' . $login_email . '</td></tr>' : '') .
      ($login_phone !='' ? '<tr><td class="extra-info-bold">' . OFFICE_LOGIN_PHONE . '</td><td>' . $login_phone . '</td></tr>' : '') .
      ($login_fax !='' ? '<tr><td class="extra-info-bold">' . OFFICE_LOGIN_FAX . '</td><td>' . $login_fax . '</td></tr>' : '') .
//MY NEW CODE STARTS HERE - BUT ONLY THE LAST FIELD SHOWS UP
      '<tr><td class="extra-info-bold">' . 'Partner: ' . '</td><td>' . $result->fields['customers_partner'] . '</td></tr>' .
      '<tr><td class="extra-info-bold">' . 'Due Date: ' . '</td><td>' . $result->fields['customers_duedate'] . '</td></tr>' .
      '<tr><td class="extra-info-bold">' . 'Dr or Midwife: ' . '</td><td>' . $result->fields['customers_drmidwife'] . '</td></tr>' .
      '<tr><td class="extra-info-bold">' . 'Delivery Location: ' . '</td><td>' . $result->fields['customers_delivering'] . '</td></tr>' .
//END MY NEW CODE HERE     
      '<tr><td class="extra-info-bold">' . 'Referral Source: ' . '</td><td>' . $result->fields['customers_referral'] . '</td></tr>' .
      '<tr><td class="extra-info-bold">' . OFFICE_IP_ADDRESS . '</td><td>' . $_SESSION['customers_ip_address'] . ' - ' . $_SERVER['REMOTE_ADDR'] . '</td></tr>' .
      '<tr><td class="extra-info-bold">' . OFFICE_HOST_ADDRESS . '</td><td>' . $email_host_address . '</td></tr>' .
      '<tr><td class="extra-info-bold">' . OFFICE_DATE_TIME . '</td><td>' . date('D M j Y G:i:s T') . '</td></tr>' . '</table>';
    return $extra_info;
  }
Any ideas?
Thanks so much!
-KL