$sql = "SELECT concat(IFNULL(c.region_name, ‘‘), ‘  ‘, IFNULL(p.region_name, ‘‘), " .

                "‘  ‘, IFNULL(t.region_name, ‘‘), ‘  ‘, IFNULL(d.region_name, ‘‘)) AS region " .

            "FROM " . $GLOBALS[‘ecs‘]->table(‘order_info‘) . " AS o " .

                "LEFT JOIN " . $GLOBALS[‘ecs‘]->table(‘region‘) . " AS c ON o.country = c.region_id " .

                "LEFT JOIN " . $GLOBALS[‘ecs‘]->table(‘region‘) . " AS p ON o.province = p.region_id " .

                "LEFT JOIN " . $GLOBALS[‘ecs‘]->table(‘region‘) . " AS t ON o.city = t.region_id " .

                "LEFT JOIN " . $GLOBALS[‘ecs‘]->table(‘region‘) . " AS d ON o.district = d.region_id " .

            "WHERE o.order_id = ‘$order[order_id]‘";

       $res = $GLOBALS[‘db‘]->getRow($sql);

       $smarty->assign(‘address‘,$res[‘region‘]);

在user.php中的

elseif ($action == ‘order_detail‘)里面加上上面那句话

在user_transaction.dwt中找到对应的代码显示出来即可

修改ecshop让订单详情里将会员地址详情全部显示