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


PHP code to find out the total price and average price is


$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’];



The Total price of products is 21.67

The Average price of products is 26.96

Bansal Sumit

To seek challenging roles and to achieve excellence in the field of Open Source Web Technology with a profound spirit of commitment and dedication.

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *