Hello to all my dear friends
I have a result set from a MySQL database from a multi-table join that contains a lot of duplicate data (not duplicate rows)
and my goal is to convert this result set into a summarized form.
(to be able to create a loop and display its data on the client side in a simpler way)
I would be grateful if you could guide me on the best way to do this.
Should I optimize the database query?
Is it better to do this summarization on the server side and by PHP?
Or is it better to do this on the client side using JavaScript?
my result set :
$result = array(
0=>array('username'=>'jack','ordercode'=>1,'productName'=>'x'),
0=>array('username'=>'jack','ordercode'=>1,'productName'=>'y'),
0=>array('username'=>'jack','ordercode'=>2,'productName'=>'z'),
0=>array('username'=>'steven','ordercode'=>3,'productName'=>'g'),
0=>array('username'=>'steven','ordercode'=>3,'productName'=>'j'),
);
and my ideal result set :
$result = array(
0=>array(
'username'=>array(
'jack'=>array(
'ordername'=>array(
'1'=>array(
'x','y'
),'2'=>array(
'z'
)
)
),'steven'=>array(
'ordername'=>array(
'3'=>array(
'g','j'
)
)
)
))
);
