How to convert sql statement to multi array

[yuexuan]

hi
i am newbie for php , now i facing problem like this
How to change this sql statement to this multi array format

Code: Select all

                  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

[Rakuli]

Okay, so that's not an SQL query it is just some data.

How are you pulling the data out of the database and what is the table structure? It's impossible to answer your question with the given info.

Cheers