$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中找到对应的代码显示出来即可
原文：http://www.cnblogs.com/GmrBrian/p/4170814.html