ecshop订单确认中显示省市地址信息的方法_php技巧

$sql = "select region_name from ".$GLOBALS['ecs']->table('region') . " where region_id in(".$arr['country'].",".$arr['province'].",". $arr['city'].",".$arr['district'].")"; 
$address = $GLOBALS['db']->getAll($sql); 
foreach($address as $value) 
{ 
$arr['address1'] .= $value['region_name']."-"; 
}