显示数组的值？

Question

<?php
    $result = $mysqli->query(SELECT SUM(Answer) as answer FROM answers WHERE SID ='$uname'");
            $Sum = $result->fetch_row();
    var_dump($Sum);
?>

When executing the above code I get the following: Array ( [SUM(Answer)] => 8 ), however, when I try to access $Sum[0] I get the following Undefined offset: 0 and it prints nothing. I need to use this variable in an echo statement. Also, $Sum['Answer'] prints nothing, and I got a message saying undefined index Answer.

Answer 1

If you want to print the value of an array or object and show all of its members / properties, use the print_r function.

print_r($Sum);

or, for better formatting on a webpage:

echo '<pre>' . print_r($Sum, true) . '</pre>';

---

After your edit: The var_dump is correct, you need to access your column by its name, like this:

$Sum['SUM(Answer)']

If you don't like this, change the name of your column (SELECT SUM(Answer) AS sum FROM... or something like that, then you can do $Sum['sum']).