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');
Copy Clear
Copy Format Clear
<?php $total = 0; $email=$row["email"]; $prix=$row["prix"]; $query = mysqli_query( $con , " select email , sum(prix) from ribhnumsoldeclien group by email " ); foreach($query as $row) { $total= number_format( $total + $prix , 2 ) ; echo $row["email"]; echo $total; }
Show:  
Copy Clear