select sum(left(name,3)='A县')*R1 as 'A县',sum(left(name,6)='A县A乡')*R1 as 'A县A乡',sum(left(name,6)='A县B乡')*R1 as 'A县B乡' from test3;
- -! try: ================================ $sql = "select sum(left(name,3)='A县')*R1 as 'A县',sum(left(name,6)='A县A乡')*R1 as 'A县A乡',sum(left(name,6)='A县B乡')*R1 as 'A县B乡' from $tab";
to :foolbirdflyfirst(湖水清澈@Fix my lover@) 我还有B县C县..... 请问如果用数组能实现分组吗?
as 'A县A乡',sum(left(name,6)='A县B乡')*R1 as 'A县B乡' from test3;
try:
================================
$sql = "select sum(left(name,3)='A县')*R1 as 'A县',sum(left(name,6)='A县A乡')*R1
as 'A县A乡',sum(left(name,6)='A县B乡')*R1 as 'A县B乡' from $tab";
我还有B县C县.....
请问如果用数组能实现分组吗?
举一个二维数组为例子:
===========================================
$arr = array(
array('532901101001','A县A乡A村','11'),
array('532901101002','A县A乡B村','11'),
array('532901102001','A县B乡A村','11'),
array('532901102002','A县B乡B村','11')
);
foreach($arr as $key=>$value)
{
$key1 = substr($value[1],0,3);
$key2 = substr($value[1],0,6);
$newArr[$key1] += $value[2];
$newArr[$key2] += $value[2];
}
print_r($newArr);
那就要分析你的数组结构,和数据了.
举一个二维数组为例子:
===========================================
$arr = array(
array('532901101001','A县A乡A村','11'),
array('532901101002','A县A乡B村','11'),
array('532901102001','A县B乡A村','11'),
array('532901102002','A县B乡B村','11')
);
foreach($arr as $key=>$value)
{
$key1 = substr($value[1],0,3);
$key2 = substr($value[1],0,6);
$newArr[$key1] += $value[2];
$newArr[$key2] += $value[2];
}
print_r($newArr);