Mysql Query sum of a column not displaying

Question

Any idea why this isn't working? When i run it it doesn't display anything.

$qry = mysql_query(" SELECT SUM(payment_received) AS total FROM Orders ");
   {
 $row = mysql_fetch_assoc($qry);
echo $row['total'];
}

Thanks for any help.

Did you check if the query succeeded? $qry = mysql_query(...) or die(mysql_error());. Never assume a query succeeds. They can succeed in exactly ONE way, and fail in a near infinite number of ways. Assume failure, and treat success as a pleasant surprise. — Marc B
– Marc B, Commented Jan 13, 2014 at 14:30
you should not be using mysql_* functions in the first place, they have been deprecated for a while. — SirDarius
– SirDarius, Commented Jan 13, 2014 at 14:37

miltos · Accepted Answer · 2014-01-13 14:40:12Z

1

Correct your code with the following example

$qry = mysql_query("SELECT SUM(payment_received) AS total FROM Orders");
while ($row = mysql_fetch_assoc($qry)) {
{
    echo $row["total"];
}

answered Jan 13, 2014 at 14:40

miltos

1,0191 gold badge6 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

aconrad · Accepted Answer · 2014-01-13 14:35:41Z

1

$result = mysql_query("SELECT SUM(payment_received) AS total FROM Orders") or die(mysql_error());
$row = mysql_fetch_assoc($result);
print_r($row);

answered Jan 13, 2014 at 14:35

aconrad

5866 silver badges12 bronze badges