PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE `ribhnumsoldeclien` ( `id` int(20) PRIMARY KEY NOT NULL AUTO_INCREMENT, `email` varchar(100) NOT NULL, `prix` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; INSERT INTO `ribhnumsoldeclien` (`id`, `email`, `prix`) VALUES (1, 'mehdi@gmail.com', '4.5'), (2, 'mehdi@gmail.com', '4.5'), (3, 'ayoub@gmail.com', '4.5'), (4, 'ayoub@gmail.com', '4.5'); SELECT email, SUM(prix) AS total_prix FROM ribhnumsoldeclien GROUP BY email;
Copy Clear
Copy Format Clear
<?php $query = mysqli_query($mysqli, "SELECT email, SUM(prix) AS total_prix FROM ribhnumsoldeclien GROUP BY email"); $array2=array(); while($row=mysqli_fetch_assoc($query)) { array_push($array2, $row); } print_r($array2 ) ; ?>
Show:  
Copy Clear