😕
Trying to create a multi-dimensional that once populated, will need to be sorted by one or more of its keys at a later time. The array would be populated by multiple SQL queries. The query result would be sent to a temporary array for immediate printing, and the multi-dim array will be used for totaling.
Trying to create the array in this fashion:
gmmdivarray [gmmid][divid][prod][sales data array]
Currently, I have the following code:
while($row = pg_fetch_row($result))
{
//This represents the the column names for [$row[8]],[$row[9]], etc
// gmm div prod sales
This appears to work, and I can see data, however, I'm not sure how to sort the data with array_multisort()
$gmmdivarray [$row[8]][$row[9]][$row[0]][lwunit] = $row[5];
$gmmdivarray [$row[8]][$row[9]][$row[0]][lwddol] = $row[2];
$gmmdivarray [$row[8]][$row[9]][$row[0]][ptdunit] = $row[6];
$gmmdivarray [$row[8]][$row[9]][$row[0]][ptddol] = $row[3];
$gmmdivarray [$row[8]][$row[9]][$row[0]][stdunit] = $row[7];
$gmmdivarray [$row[8]][$row[9]][$row[0]][stddol] = $row[4];
/*
// So I thought maybe I should do it individually, but all I get is 1 row
$gmmdivarray [gmmid] = $row[8];
$gmmdivarray [gmmid][divid]= $row[9];
$gmmdivarray [gmmid][divid][prod]= $row[0];
$gmmdivarray [gmmid][divid][prod][lwunit] = $row[5];
$gmmdivarray [gmmid][divid][prod][lwddol] = $row[2];
$gmmdivarray [gmmid][divid][prod][ptdunit] = $row[6];
$gmmdivarray [gmmid][divid][prod][ptddol] = $row[3];
$gmmdivarray [gmmid][divid][prod][stdunit] = $row[7];
$gmmdivarray [gmmid][divid][prod][lwddol] = $row[2];
*/
$i++;
}
}
Could someone tell me what I'm doing wrong and how to fix it?
TIA
Patrick
