Online PHP editor | refs for lviAI

<?php $result = [ ['color' => 'black', 'price' => 15], ['color' => 'white', 'price' => 25], ['color' => 'green', 'price' => 35], ['color' => 'black', 'price' => 45], ]; // Truth: A mysql result set object ($result) is iterable so you can just feed it to a foreach loop! $a = []; foreach ($result as $row) { $a[$row['color']]['price'] = ($a[$row['color']]['price'] ?? 0) + $row['price']; } var_export($a);