从MySQL表中提取数据,数据看起来像:
Acct # Acct Name Item Date Sold Qty Sold
10293 Company A Canon JX200 2012-06-24 1
11042 Company B Canon JX200 2012-06-05 2
12560 Company D Canon L90 2012-04-20 1
12560 Company D Canon L90 2012-05-07 1
14160 Company D Canon L90 2012-05-22 2
14168 Company C Canon L90 2012-04-20 6
我想要的输出看起来像:
Acct # Acct Name Item Mo 1 Mo 2 Mo 3 Mo 4 Mo 5 Mo 6 Tot
10293 Company A Canon JX200 1 1
11042 Company B Canon JX200 2 2
12560 Company C Canon L90 6 6
12560 Company D Canon L90 1 3 4
大学里的Aced 2线性代数课程和php数组让我不知所措。需要将我的数据放入数组,进行排序和汇总。最大的问题(我认为)是构造数组的代码。提前感谢!
为此,您可以使用透视表。http://en.wikibooks.org/wiki/MySQL/Pivot_table
尝试通过addnf ORDER by账户名称对MySQL查询中的数据进行排序。当你收到数据时,这个代码应该会有所帮助:
$data = array();
foreach ($rows as $row) {
preg_match('/^'d{4}'-('d{2})'-/', $row['DateSold'], $match);
$data[] = array(
'Acct' => $row['Acct'],
'AcctName' => $row['AcctName'],
'Item' => $row['Item'],
'Mo ' . $match[1] => $row['QtySold']
);
}