Cannot get SUM() in MYSQL

Question

I am trying to get the SUM of a column SnappersScore from a table LastResult. However, there is nothing in the output at all. Not even an error. Any ideas about what I am doing wrong?

Here it is:

<?php

mysql_connect(xxxxxx);
if (mysql_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysql_connect_error();
  }

$result = mysql_query('SELECT SUM(SnappersScore) AS TotalGoals FROM LastResult');
$row = mysql_fetch_assoc($result);
$sum = $row['TotalGoals'];

echo $sum;

?>

Have you tried checking what $result contains after running the query? If it is false, an SQL error occured. — Dragony
– Dragony, Commented Oct 11, 2013 at 15:36
There is no more support for mysql_* functions, they are officially deprecated, no longer maintained and will be removed in the future. You should update your code with PDO or MySQLi to ensure the functionality of your project in the future. — Naftali
– Naftali, Commented Oct 11, 2013 at 15:36
have you run the query against database and see the result? is it giving you result you want? — AJP
– AJP, Commented Oct 11, 2013 at 15:36
I have run the query in the database and got the intended result. — geoff_goode
– geoff_goode, Commented Oct 11, 2013 at 15:40
TotalGoals = 0? Which when echo'd out becomes the string "" ... so you'll see nothing? — CD001
– CD001, Commented Oct 11, 2013 at 15:40

Prisoner · Accepted Answer · 2013-10-11 15:37:38Z

1

Only you can debug this, see what the error is:

$result = mysql_query('SELECT SUM(SnappersScore) AS TotalGoals FROM LastResult') or die(mysql_error());

I'll save you the repetitive "dont use mysql_*, don't use die in production bla bla bla" - this should point you in the right direction.

This is of course, assuming that when running SELECT SUM(SnappersScore) AS TotalGoals FROM LastResult in SQL works as expected.

answered Oct 11, 2013 at 15:37

Prisoner

27.7k11 gold badges78 silver badges104 bronze badges

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

Collectives™ on Stack Overflow

Cannot get SUM() in MYSQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related