PHP Column Sum Result MYSQL

Question

$query = "SELECT SUM(Veldspar) FROM hauled WHERE miningrun=2 AND hauler=1";
$result = mysql_query($query) or die(mysql_error());
$veldtotal = mysql_fetch_array($result);

printf("Results:  %s<br>", $veldtotal);
printf("Length of array: %s<br>", count($veldtotal));
printf("Array into Int: %s<br>", (int)$veldtotal);

Why does the first printf return a blank variable?
All I want to be able to do is to get the sum of the query, and pass it to a variable to be displayed on the screen. Can anyone help with this?

if this code is new, please avoid mysql_* functions, prefer PDO and mysqli features. — luchosrock
– luchosrock, Commented Dec 19, 2012 at 18:05
The rest of the project is not new. I am adding a new feature to an existing opensource project, and I cannot use other things than what is there in the rest of the project. — user1916443
– user1916443, Commented Dec 19, 2012 at 18:35

cypher · Accepted Answer · 2012-12-19 18:02:59Z

2

That would be because mysql_fetch_array returns an array. You can get to the result using $veldtotal[0].

answered Dec 19, 2012 at 18:02

cypher

7,0024 gold badges34 silver badges48 bronze badges

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

1 Comment

user1916443 Over a year ago

I edited the code as you said, and the return I received when running was the following:<br> Results:

swapnesh · Accepted Answer · 2012-12-19 18:06:08Z

0

Use this or var_dump() to know what ur getting in $veldtotal

echo "<pre>";
print_r($veldtotal);

answered Dec 19, 2012 at 18:06

swapnesh

26.8k24 gold badges97 silver badges129 bronze badges

2 Comments

luchosrock Over a year ago

but wouldn't you get a single value from the SUM() in SQL?, I mean the statement, as it is written will only come up with a single row with the SUM of veldspar

user1916443 Over a year ago

I only want a single row answer as after I pull the value, I will have to do math on it and then store it in a different array.

ennovativemedia · Accepted Answer · 2012-12-19 18:10:21Z

0

If you want to access the calculated sum in your query, you should name it:

$query = "SELECT SUM(Veldspar) AS total FROM hauled WHERE miningrun = 2 AND hauler = 1";

And read it:

printf("Results:  %s<br>", $veldtotal['total']);
printf("Length of array: %s<br>", count($veldtotal));
printf("Array into Int: %s<br>", (int)$veldtotal);

You can also read it by using $veldtotal[0]

answered Dec 19, 2012 at 18:10

ennovativemedia

3611 silver badge7 bronze badges

2 Comments

user1916443 Over a year ago

Tried this solution, and it still returned a blank answer. When I add the debug condition in as another user suggested the array had no value in it, but when I do the query on the sql server it returns a value.

ennovativemedia Over a year ago

Try reading the values in $veldtotal by using <pre><?php print_r($veldtotal); ?></pre> after the query. If the sum is shown, then try changing your printf-statement by an echo.

luchosrock · Accepted Answer · 2012-12-19 18:10:48Z

0

$query = "SELECT SUM(Veldspar) FROM hauled WHERE miningrun=2 AND hauler=1";

$veldtotal = mysql_result(mysql_query($query), 0, 0);

printf("Results:  %s<br>", $veldtotal);
printf("Length of array: %s<br>", count($veldtotal));
printf("Array into Int: %s<br>", (int)$veldtotal);

Besides, what does Length of array mean?

answered Dec 19, 2012 at 18:10

luchosrock

70610 silver badges24 bronze badges

1 Comment

user1916443 Over a year ago

I wanted to make sure I was getting an array of some length.

Collectives™ on Stack Overflow

PHP Column Sum Result MYSQL

4 Answers 4

1 Comment

2 Comments

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

2 Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related