Hmm... I need to find out myself. I don't know what is the right answer to your question. I'll do some investigation and get back to you if I bump into an decent answer. You should email the people at Verisign as they probably can answer it..
Add this code to.
$fax_query = tep_db_query("select customers_fax from "TABLE_CUSTOMERS" where customers_id = '"(int)$customer_id"'");.
$fax = tep_db_fetch_array($fax_query);.
Then where you want to use the fax number do it similar to this:.
Note to the previous poster:.
Trying to "one up" you here..
I started piddling with the code to do this, and when I get ready to post it I find someone else has already replied!.
So, I thought I'd just post my code anyway since I spent the time to work on it...
None taken, I find your way easier, in this way, is there no need to add fax number field in the classes/order.php??..
No need that I can see to make any other changes. All the OP wants to do is add it to the email not to the order that gets stored in the DB..
I tested this code and it worked (in another PHP file)..
Although simply adding the fax number to the query already in the code (like you've suggested) would be better..
Trouble is I can't test that!.
And I'm not sure I could even do it successfully..
I'm not very MYSQL literate..
That's why I took the approach I did...
I really appreciate your time..
I am having a problem with adding the customer fax number into the order confirmation email.
I can insert the customers telephone number into the email no problem by adding the line.
File in the catalog directory.
But when I enter fax, the information doesnt show up........
Any help or insight into this will be greatly appricated.
First you should have a field called customers_fax in customer table (most probably this is already there).
In checkout_process.php, below $payment_modules->before_process();.
Look for $sql_data_array = array('customers_id' => $customer_id,.
In there below customer_telephone add.
'customers_fax' => $order->customer['fax'],.
Open catalog/includes/classes/order.php.. look for $order_id = tep_db_prepare_input($order_id); $order_query = tep_db_query(.
Look for $this->customer = array('id' same page.. add.
'fax' => $order['customers_fax'],.
Look for $customer_address_query = tep_db_query( add.
Look for $this->customer = array('firstname' => $customer_address['customers_firstname'], add.
'fax' => $customer_address['customers_fax'],.
To make this appear in admin/order.php.
Make changes in admin/order.php.
Add this above include(DIR_WS_CLASSES'order.php');.
// Look up things in orders.
$the_extra_query= tep_db_query("select * from "TABLE_ORDERS" where orders_id = '"(int)$oID"'");.
// Look up things in customers.
$the_extra_query= tep_db_query("select * from "TABLE_CUSTOMERS" where customers_id = '"$the_customers_id"'");.
Add this where you need to show the fax no..
<td class="main"><b><?php echo 'FAX #:'; ?></b></td>.
<td class="main"><?php echo $the_customers_fax; ?></td>.