hi
i now still new for php , me now facing a problem like this
求助 請問 如何把這個sql 轉進這個mutli arry ?
SELECT SUM(RAW_AMOUNT) as TotalRawAmount, SUM(FG_AMOUNT) as TotalFGAmount, SUM(WIP) as TotalWIPAmount, UPLOAD_DATE FROM raw_fg_sum GROUP by UPLOAD_DATE";how to store data into to this multi array 19/2/2007 21/3/08 2/1/2008 4/3/2008 <--UPLOAD_DATE
TotalRawAMount 1000 2011 1111 2333
TotalFGAmount 212 122 21 21
TotalWIPAmount 212 122 21 211
$arrData[0][0] =""
$arrData[1][0] = "TotalRawAmount";
$arrData[2][0] = "TotalFgAmount";
$arrData[3][0] = "TotalWIPAmount";
data for TotalRawAmount
$arrData[1][1] = 1000;
$arrData[1][2] = 2011;
$arrData[1][3] = 1111;
$arrData[1][4] = 2333;
// Dara for TotalFGAmount
$arrData[2][1] = 212;
$arrData[2][2] = 122;
$arrData[2][3] = 21;
$arrData[2][4] = 21;
// Data for TotalWIGAmount
$arrData[3][1] = 212;
$arrData[3][2] = 122;
$arrData[3][3] = 211;
$arrData[3][4] = 21;
DataFOr UPload_date
$arrDate[0][1]=19/2/07
$arrDate[0][2]=21/3/08
$arrDate[0][3]=2/1/08
$arrDate[0][4]=4/3/08
thanks
i now still new for php , me now facing a problem like this
求助 請問 如何把這個sql 轉進這個mutli arry ?
SELECT SUM(RAW_AMOUNT) as TotalRawAmount, SUM(FG_AMOUNT) as TotalFGAmount, SUM(WIP) as TotalWIPAmount, UPLOAD_DATE FROM raw_fg_sum GROUP by UPLOAD_DATE";how to store data into to this multi array 19/2/2007 21/3/08 2/1/2008 4/3/2008 <--UPLOAD_DATE
TotalRawAMount 1000 2011 1111 2333
TotalFGAmount 212 122 21 21
TotalWIPAmount 212 122 21 211
$arrData[0][0] =""
$arrData[1][0] = "TotalRawAmount";
$arrData[2][0] = "TotalFgAmount";
$arrData[3][0] = "TotalWIPAmount";
data for TotalRawAmount
$arrData[1][1] = 1000;
$arrData[1][2] = 2011;
$arrData[1][3] = 1111;
$arrData[1][4] = 2333;
// Dara for TotalFGAmount
$arrData[2][1] = 212;
$arrData[2][2] = 122;
$arrData[2][3] = 21;
$arrData[2][4] = 21;
// Data for TotalWIGAmount
$arrData[3][1] = 212;
$arrData[3][2] = 122;
$arrData[3][3] = 211;
$arrData[3][4] = 21;
DataFOr UPload_date
$arrDate[0][1]=19/2/07
$arrDate[0][2]=21/3/08
$arrDate[0][3]=2/1/08
$arrDate[0][4]=4/3/08
thanks
(PHP 4, PHP 5, PECL axis2:0.1.0-0.1.1)
serialize — 产生一个可存储的值的表示
把结果贴上来,我就可以帮你完成剩余的工作.
我的意是把取的数据库查询结果放近multi array 我所要的這個放式
然後像這樣顯示出來
19/2/2007 21/3/08 2/1/2008 4/3/2008 <--UPLOAD_DATE
TotalRawAMount 1000 2011 1111 2333
TotalFGAmount 212 122 21 21
TotalWIPAmount 212 122 21 211我要sql 儲在這樣的array
$arrData[0][0] =""
$arrData[1][0] = "TotalRawAmount";
$arrData[2][0] = "TotalFgAmount";
$arrData[3][0] = "TotalWIPAmount";
data for TotalRawAmount
$arrData[1][1] = 1000;
$arrData[1][2] = 2011;
$arrData[1][3] = 1111;
$arrData[1][4] = 2333;
// Dara for TotalFGAmount
$arrData[2][1] = 212;
$arrData[2][2] = 122;
$arrData[2][3] = 21;
$arrData[2][4] = 21;
// Data for TotalWIGAmount
$arrData[3][1] = 212;
$arrData[3][2] = 122;
$arrData[3][3] = 211;
$arrData[3][4] = 21;
DataFOr UPload_date
$arrDate[0][1]=19/2/07
$arrDate[0][2]=21/3/08
$arrDate[0][3]=2/1/08
$arrDate[0][4]=4/3/08