</tr>
      <tr>
        <td class="main"><font color="#ff0000"><?php 
    echo sprintf(TEXT_AFTER_EMAIL_INSTRUCTIONS, $i);
    ?>
</font></td>
      </tr>
      <tr>
        <td><?php 
    echo zen_draw_separator('pixel_trans.gif', '1', '10');
    ?>
</td>
      </tr>
      <tr>
        <td align="center"><?php 
    zen_restore_language($_POST['admin_language']);
    echo '<a href="' . zen_href_link(FILENAME_NEWSLETTERS, 'page=' . $_GET['page'] . '&nID=' . $_GET['nID']) . '">' . zen_image_button('button_back.gif', IMAGE_BACK) . '</a>';
    ?>
</td>
      </tr>
<?php 
} else {
    ?>
      <tr>
        <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
          <tr>
            <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
              <tr class="dataTableHeadingRow">
                <td class="dataTableHeadingContent"><?php 
    echo TABLE_HEADING_NEWSLETTERS;
    ?>
         $reviews = $db->Execute("select reviews_id\r\n                                   from " . TABLE_REVIEWS . "\r\n                                   where customers_id = '" . (int) $customers_id . "'");
         while (!$reviews->EOF) {
             $db->Execute("delete from " . TABLE_REVIEWS_DESCRIPTION . "\r\n                        where reviews_id = '" . (int) $reviews->fields['reviews_id'] . "'");
             $reviews->MoveNext();
         }
         $db->Execute("delete from " . TABLE_REVIEWS . "\r\n                        where customers_id = '" . (int) $customers_id . "'");
     } else {
         $db->Execute("update " . TABLE_REVIEWS . "\r\n                        set customers_id = null\r\n                        where customers_id = '" . (int) $customers_id . "'");
     }
     $db->Execute("delete from " . TABLE_ADDRESS_BOOK . "\r\n                      where customers_id = '" . (int) $customers_id . "'");
     $db->Execute("delete from " . TABLE_CUSTOMERS . "\r\n                      where customers_id = '" . (int) $customers_id . "'");
     $db->Execute("delete from " . TABLE_CUSTOMERS_INFO . "\r\n                      where customers_info_id = '" . (int) $customers_id . "'");
     $db->Execute("delete from " . TABLE_CUSTOMERS_BASKET . "\r\n                      where customers_id = '" . (int) $customers_id . "'");
     $db->Execute("delete from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . "\r\n                      where customers_id = '" . (int) $customers_id . "'");
     $db->Execute("delete from " . TABLE_WHOS_ONLINE . "\r\n                      where customer_id = '" . (int) $customers_id . "'");
     zen_restore_language($admin_language);
     zen_redirect(zen_href_link(FILENAME_CUSTOMERS, zen_get_all_get_params(array('cID', 'action')), 'NONSSL'));
     break;
 default:
     // ->furikana
     if (FURIKANA_NESESSARY) {
         $customers = $db->Execute("select c.customers_id, c.customers_gender, c.customers_firstname,\r\n                                            c.customers_lastname, c.customers_dob, c.customers_email_address,\r\n                                            c.customers_firstname_kana, c.customers_lastname_kana,\r\n                                            a.entry_company, a.entry_street_address, a.entry_suburb,\r\n                                            a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id,\r\n                                            a.entry_country_id, a.entry_telephone, a.entry_fax,\r\n                                            c.customers_newsletter, c.customers_default_address_id,\r\n                                            c.customers_email_format, c.customers_group_pricing,\r\n                                            c.customers_authorization, c.customers_referral\r\n                                    from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a\r\n                                    on c.customers_default_address_id = a.address_book_id\r\n                                    where a.customers_id = c.customers_id\r\n                                    and c.customers_id = '" . (int) $customers_id . "'");
     } else {
         $customers = $db->Execute("select c.customers_id, c.customers_gender, c.customers_firstname,\r\n                                            c.customers_lastname, c.customers_dob, c.customers_email_address,\r\n                                            a.entry_company, a.entry_street_address, a.entry_suburb,\r\n                                            a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id,\r\n                                            a.entry_country_id, a.entry_telephone, a.entry_fax,\r\n                                            c.customers_newsletter, c.customers_default_address_id,\r\n                                            c.customers_email_format, c.customers_group_pricing,\r\n                                            c.customers_authorization, c.customers_referral\r\n                                    from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a\r\n                                    on c.customers_default_address_id = a.address_book_id\r\n                                    where a.customers_id = c.customers_id\r\n                                    and c.customers_id = '" . (int) $customers_id . "'");
     }
     // <-furikana
     // -> set number_of_reviews in $cInfo (jp6)
     //        $cInfo = new objectInfo($customers->fields);
     $reviews = $db->Execute("select count(*) as number_of_reviews\r\n                                 from " . TABLE_REVIEWS . " where customers_id = '" . (int) $customers->fields['customers_id'] . "'");
     $cInfo_array = array_merge($customers->fields, $reviews->fields);
     $cInfo = new objectInfo($cInfo_array);