Online PHP editor | output for 6NfOm

<?php // what i wanna do with this script is for each color, create an array that has the total price(my table has some items that have the same color but with different prices) $a = array(); while($row = mysqli_fetch_assoc($result)) { // create an array of each color, eg: $a["black"] $a["$row[color]"] = array(); // if the price key in the $a["black"] exists then add its value to the new one if(array_key_exists("price", $a["$row[color]"])) { $a["$row[color]"]["price"] += $row["price"]; } else { $a["$row[color]"]["price"] = $row["price"]; } } ?>