12 Oct 2009, 8:28 PM
Zen Follower
- Join Date:
- Aug 2004
- Posts:
- 93
- Plugin Contributions:
- 0
mysql query for order details?
I'm not good at writing a mysql query. I'm trying to find a way to export a file to excel that contains all orders to a specific country. The file needs to contain the order id, name, address, country, date of sale, and contents of order. I can do everything in need by exporting the order file from the database, and sorting by country, except the contents of the order. Can someone tell me how to get the order contents into the file?
Thanks,
billt