How to calculate an order?

Question

PHP

There is a table in Mysql where the quantity of goods and its price are indicated, how to display the final number that will add up all the numbers of the number * price?

$result = mysql_query("SELECT * FROM zakaz WHERE idcom = $idco",$db);
$myrow = mysql_fetch_array($result);
$pr = 0;
do
{

  while($myrow = mysql_fetch_array($result));

There is a cycle, but how to display the final result?

Answer 1

dev.mysql.com/doc/refman/5.7/en/mathematical-funct...