Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

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

Link to comment
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




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


Good luck!




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 ...

Link to comment
Share on other sites


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

  • Create New...