Calculate average and sum from Mysql query
The AVG function return the average value of the specified column. For example I have a table of product list and now I want the total of price and average price of all the products.
id | name | price |
---|---|---|
43245 | Jeans | 19.99 |
43246 | Top | 3.99 |
43247 | Playstation | 89.95 |
43248 | Men’s T-Shirt | 32.50 |
43249 | Shirt | 34.97 |
43250 | Laptop | 3.99 |
43251 | Mobile | 21.55 |
43252 | Lemon | 8.73 |
Code:
PHP code to find out the total price and average price is
<?php
$query = “SELECT AVG(price)as priceavg, SUM(`price`) as pricesum FROM products”;
$result = mysql_query($query);
$row = mysql_fetch_array($result);
echo “The Total price of products is “. $row[‘pricesum’];
echo “<br />”;
echo “The Average price of products is “. $row[‘priceavg’];
?>
Output:
The Total price of products is 21.67
The Average price of products is 26.96