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.

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