In the context of the query you quoted,FROM " . TABLE_ORDERS_STATUS . " os, " . TABLE_ORDERS_STATUS_HISTORY . " osh
os is a shortname/alias for TABLE_ORDERS_STATUS
osh is an alias for TABLE_ORDERS_STATUS_HISTORY
Thus, osh.tracking_number would refer to a field named "tracking_number" in the orders_status_history table.
And your latest error message indicates that no such field exists in that table.
Results 1 to 7 of 7
Threaded View
-
27 Sep 2013, 12:19 AM #6
Sensei
- Join Date
- Jan 2004
- Posts
- 66,443
- Plugin Contributions
- 279
Re: Can I read in data from the database?
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
Reply With QuoteSimilar Threads
-
Exporting cutomer purchase data from the database to Excel spreadsheet file
By Derek Bryant in forum General QuestionsReplies: 3Last Post: 15 Jul 2013, 08:02 AM -
Is this a bug? can barely upload new data to the database
By Thannaree in forum General QuestionsReplies: 13Last Post: 16 Mar 2011, 10:03 AM -
Can I export the zen cart database from the admin?
By jettrue in forum General QuestionsReplies: 2Last Post: 13 Apr 2009, 08:11 AM -
Can no longer read database
By tedpottel in forum Installing on a Linux/Unix ServerReplies: 1Last Post: 24 Oct 2008, 11:08 PM
