#单独查询
select
delivery_company,
delivery_street_address,
delivery_postcode,
delivery_name,
customers_telephone,
delivery_state,
delivery_city,
date_purchased,
delivery_country
from orders where orders_id='14731' order by date_purchased asc limit 0,10;
+------------------+-------------------------+-------------------+---------------+---------------------+----------------+---------------+---------------------+------------------+
| delivery_company | delivery_street_address | delivery_postcode | delivery_name | customers_telephone | delivery_state | delivery_city | date_purchased | delivery_country |
+------------------+-------------------------+-------------------+---------------+---------------------+----------------+---------------+---------------------+------------------+
| | weicot.com 10086 | 112110 | jiang liu | 520-1314-748 | Texas | xiamen | 2015-08-03 21:40:51 | United States |
+------------------+-------------------------+-------------------+---------------+---------------------+----------------+---------------+---------------------+------------------+
+-----------------------------+---------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------------+---------------+------+-----+---------+----------------+
| orders_id | int(11) | NO | PRI | NULL | auto_increment |
| customers_id | int(11) | NO | MUL | 0 | |
| customers_name | varchar(256) | YES | | NULL | |
| customers_company | varchar(64) | YES | | NULL | |
| customers_street_address | varchar(64) | NO | | | |
| customers_suburb | varchar(32) | YES | | NULL | |
| customers_city | varchar(32) | NO | | | |
| customers_postcode | varchar(10) | NO | | | |
| customers_state | varchar(32) | YES | | NULL | |
| customers_country | varchar(32) | NO | | | |
| customers_telephone | varchar(32) | NO | | | |
| customers_email_address | varchar(256) | YES | | NULL | |
| customers_address_format_id | int(5) | NO | | 0 | |
| delivery_name | varchar(256) | YES | | NULL | |
| delivery_company | varchar(64) | YES | | NULL | |
| delivery_street_address | varchar(64) | NO | | | |
| delivery_suburb | varchar(32) | YES | | NULL | |
| delivery_city | varchar(32) | NO | | | |
| delivery_postcode | varchar(10) | NO | | | |
| delivery_state | varchar(32) | YES | | NULL | |
| delivery_country | varchar(32) | NO | | | |
| delivery_address_format_id | int(5) | NO | | 0 | |
| billing_name | varchar(256) | YES | | NULL | |
| billing_company | varchar(64) | YES | | NULL | |
| billing_street_address | varchar(64) | NO | | | |
| billing_suburb | varchar(32) | YES | | NULL | |
| billing_city | varchar(32) | NO | | | |
| billing_postcode | varchar(10) | NO | | | |
| billing_state | varchar(32) | YES | | NULL | |
| billing_country | varchar(32) | NO | | | |
| billing_address_format_id | int(5) | NO | | 0 | |
| payment_method | varchar(128) | NO | | | |
| payment_module_code | varchar(32) | NO | | | |
| shipping_method | varchar(128) | NO | | | |
| shipping_module_code | varchar(32) | NO | | | |
| coupon_code | varchar(32) | NO | | | |
| cc_type | varchar(20) | YES | | NULL | |
| cc_owner | varchar(256) | YES | | NULL | |
| cc_number | varchar(32) | YES | | NULL | |
| cc_expires | varchar(4) | YES | | NULL | |
| cc_cvv | blob | YES | | NULL | |
| last_modified | datetime | YES | | NULL | |
| date_purchased | datetime | YES | MUL | NULL | |
| orders_status | int(5) | NO | MUL | 0 | |
| orders_date_finished | datetime | YES | | NULL | |
| currency | char(3) | YES | | NULL | |
| currency_value | decimal(14,6) | YES | | NULL | |
| order_total | decimal(14,2) | YES | | NULL | |
| order_tax | decimal(14,2) | YES | | NULL | |
| paypal_ipn_id | int(11) | NO | | 0 | |
| ip_address | varchar(96) | NO | | NULL | |
| dropdown | varchar(50) | YES | | NULL | |
| gift_message | varchar(100) | YES | | NULL | |
| checkbox | int(1) | YES | | NULL | |
| COWOA_order | tinyint(1) | NO | | 0 | |
| lp_avs | varchar(25) | NO | | | |
| lp_trans_num | varchar(64) | NO | | | |
| shipping_telephone | varchar(50) | YES | | NULL | |
+-----------------------------+---------------+------+-----+---------+----------------+
#delivery
#bill 账单地址 只是备用的
#Delivery:收货地址;Bill 地址：如果票（比如发票）未随或走，或者发票寄到与收货不同的地方（比如财务部），则使用新的Bill地址。
#二者可以相同，也可以不同。
#获取定单
为了保护隐私我对部分信息进行了混淆
![E)24WACSNW2]W4Y@[VMET3V](http://www.weicot.com/wp-content/uploads/2015/08/E24WACSNW2W4Y@VMET3V.jpg)
转载请注明：(●--●) Hello.My Weicot » zencart 导出带图的订单之 获取定单信息之信息汇总