Hi,
I have added some extra fields to the registration process on my stoer and added the corresponding columns in my db. Everything works very nicely, however I am trying to get the extra data sent to the admin create account email when new users sign up.

I can see from the emails I am getting that I am hacking the right part of the create_account.php file, I am clearly just not understanding what the code is doing. Here's what I have..

PHP Code:
// send additional emails

    
if (SEND_EXTRA_CREATE_ACCOUNT_EMAILS_TO_STATUS == '1' and SEND_EXTRA_CREATE_ACCOUNT_EMAILS_TO !='') {

      if (
$_SESSION['customer_id']) {

        
$account_query "select customers_firstname, customers_lastname, customers_email_address, customers_telephone, customers_mobile, customers_fax, customers_qualified_unqualified, customers_how_long, customers_academy_details, customers_qualifications, customers_products_used

                            from " 
TABLE_CUSTOMERS "

                            where customers_id = '" 
. (int)$_SESSION['customer_id'] . "'";



        
$account $db->Execute($account_query);

      }

 
// ######################  ADDITIONAL CUSTOMER INFORMATION SENT TO EMAIL NOTIFICATION #################### //
      
$extra_info=email_collect_extra_info($name,$email_address,$telephone,$mobile,$qualified,$how_long,$academy_details,$qualifications,$products_used,$fax$account->fields['customers_firstname'] . ' ' $account->fields['customers_lastname'], $account->fields['customers_email_address'], $account->fields['customers_telephone'], $account->fields['customers_mobile'], $account->fields['customers_qualified_unqualified'],  $account->fields['customers_how_long'],  $account->fields['customers_academy_details'],  $account->fields['customers_qualifications'],  $account->fields['customers_products_used'],  $account->fields['customers_fax']);

      
$html_msg['EXTRA_INFO'] = $extra_info['HTML'];

      if (
trim(SEND_EXTRA_CREATE_ACCOUNT_EMAILS_TO_SUBJECT) != 'n/a'zen_mail(''SEND_EXTRA_CREATE_ACCOUNT_EMAILS_TOSEND_EXTRA_CREATE_ACCOUNT_EMAILS_TO_SUBJECT ' ' EMAIL_SUBJECT,

      
$email_text $extra_info['TEXT'], STORE_NAMEEMAIL_FROM$html_msg'welcome_extra');

    } 
//endif send extra emails