Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Archived

This topic is now archived and is closed to further replies.

kieran_mullen

Display Customers Fax on orders.php

Recommended Posts

I understand most of the items pulled on orders.php (a customers order) is not pulled from the customers database but rather from the database of order history.

 

So is there a way to display a fax number on that page pulling from the customer table or would I have to make the system save it to order history and pull from the order history?

 

Any tips on how to do either way?

Thank you

Share this post


Link to post
Share on other sites

You want to display the faxnumber from the original registration of the customer?

 

There is no need to save it to the orders table then, as the customer's ID is saved in the orders table and you can join with that ID to the customers table when pulling the order in admin.

 

I guess I would modify the order class in admin/includes/classes/order.php:

 

Add an extra query to get the fax number

 

OR

 

Add a join in the select statement of the orders table.

 

Good luck!


:-)

Monika

 

addicted to writing code ... can't get enough of databases either, LOL!

 

my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum

 

Interactive Media Award July 2007 ~ category E-Commerce

my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...

Share this post


Link to post
Share on other sites

×