关于圆通速递的快递单打印模板问题~

2016-07-07 15:36 来源：www.chinab4c.com 作者：ecshop专家

修改 order.php 220 行
$sql = "SELECT concat(IFNULL(c.region_name, ''), '', IFNULL(p.region_name, ''), " .
"'', IFNULL(t.region_name, ''), '', IFNULL(d.region_name, '')) AS region " .
"FROM " . $ecs->table('order_info') . " AS o " .
"LEFT JOIN " . $ecs->table('region') . " AS c ON o.country = c.region_id " .
"LEFT JOIN " . $ecs->table('region') . " AS p ON o.province = p.region_id " .
"LEFT JOIN " . $ecs->table('region') . " AS t ON o.city = t.region_id " .
"LEFT JOIN " . $ecs->table('region') . " AS d ON o.district = d.region_id " .
"WHERE o.order_id = '$order[order_id]'";
$order['region'] = $db->getOne($sql);

修改查询sql，减少 查询的输出，可以自己再添加一个 输出

回答：
实在不懂PHP，如何增加“收件人省份”和“收件人城市”这2个变量名。。。。

管理请指教，感激不尽~~