Sum columns using MySQL/PHP

Question

My question is that why there are blank values for HW1/HW2/HW3 columns when I ran the code in the browser?.
Studentid and Sum columns displayed the code correctly. Any ideal how to fix this?

<?php

$result = mysqli_query($con,"SELECT studentid,SUM(hw1+hw2+hw3) 
FROM grade
GROUP BY studentid");

echo "<table border='1'>
<tr>
<th>StudentID</th>
<th>HW1</th>
<th>HW2</th>
<th>HW3</th>
<th>SUM</th>

</tr>";

while($row = mysqli_fetch_array($result))
 {
 echo "<tr>";
 echo "<td>" . $row['studentid'] . "</td>";
 echo "<td>" . $row['hw1'] . "</td>";
 echo "<td>" . $row['hw2'] . "</td>";
 echo "<td>" . $row['hw3'] . "</td>";
 echo "<td>" . $row['SUM(hw1+hw2+hw3)'] . "</td>";

 ;}

 echo "</table>";

 mysqli_close($con);
?>

daksh21ubuntu · Accepted Answer · 2013-03-30 19:41:07Z

1

just change your query to this

"SELECT studentid,hw1, hw2, hw3, SUM(hw1+hw2+hw3) as hw
FROM grade
GROUP BY studentid"

answered Mar 30, 2013 at 19:41

daksh21ubuntu

2762 gold badges4 silver badges14 bronze badges

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

Comments

Tim · Accepted Answer · 2013-03-30 19:34:35Z

0

Because you did not select the columns, try:

$result = mysqli_query($con, 'SELECT `studentid`, `hw1`, `hw2`, `hw3`, SUM(`hw1`+`hw2`+`hw3`) as `sum` FROM `grade` GROUP BY `studentid`');

while($row = mysqli_fetch_array($result)) {
    echo "<tr>";
    echo "<td>" . $row['studentid'] . "</td>";
    echo "<td>" . $row['hw1'] . "</td>";
    echo "<td>" . $row['hw2'] . "</td>";
    echo "<td>" . $row['hw3'] . "</td>";
    echo "<td>" . $row['sum'] . "</td>";
}

answered Mar 30, 2013 at 19:34

Tim

9631 gold badge16 silver badges32 bronze badges

1 Comment

user2227817 Over a year ago

Thanks everyone. Sorry for my poor written English above. All suggestions are correct.

Matt · Accepted Answer · 2013-03-30 19:32:40Z

0

I'm not sure, since your question is poorly written. But I think you just need to do this to get the values:

SELECT studentid,hw1,hw2,hw3,SUM(hw1+hw2+hw3)

answered Mar 30, 2013 at 19:32

Matt

1,13116 silver badges28 bronze badges

Collectives™ on Stack Overflow

Sum columns using MySQL/PHP

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related