hi
i now still new for php , me now facing a problem like this
How to convert this sql statement into this array
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
UploadDate 19/2/2007 21/3/08 2/1/2008 4/3/2008
0TotalRawAMount 1000 2011 1111 2333
1TotalFGAmount 212 122 21 21
2TotalWIPAmount 212 122 21 211
$arrData[0][1] = "TotalRawAmount";
$arrData[1][1] = "TotalFgAmount";
$arrData[2][1] = "TotalWIPAmount";
data for TotalRawAmount
$arrData[0][2] = 1000;
$arrData[1][2] = 2011;
$arrData[2][2] = 1111;
$arrData[3][2] = 2333;
// Dara for TotalFGAmount
$arrData[0][3] = 212;
$arrData[1][3] = 122;
$arrData[2][3] = 21;
$arrData[3][3] = 21;
// Data for TotalWIGAmount
$arrData[0][3] = 212;
$arrData[1][3] = 122;
$arrData[2][3] = 211;
$arrData[3][3] = 21;
DataFOr UPload_date
$arrDate[1][1]=UPloadDate
$arrDate[1][2]=19/2/07
$arrDate[1][2]=21/3/08
$arrDate[1][2]=2/1/08
$arrDate[1][2]=4/3/08
thanks