kieran_mullen Posted December 3, 2013 Posted December 3, 2013 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
♥Monika in Germany Posted December 4, 2013 Posted December 4, 2013 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 ...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.