add integers from SQL column in php

Question

Can anyone help with a query?

I have a php page that I want to assign a number to a variable, I want the number to be integers added together from a mySQL database. In this example, the numbers are in the "assigndatx" column, my query looks like this:

$AssignDates = mysql_query("select assigndatx from opencall where status < 2")

(opencall is the table, I'm only wanting those with status of 0 or 1). Can anyone help me with the code to add all the results together?

Why do it in PHP when you could do it in SQL?

Jessica
– Jessica

2013-12-13 19:33:31 +00:00
Commented Dec 13, 2013 at 19:33 — Jessica
– Jessica, Commented Dec 13, 2013 at 19:33
SUM() function maybe?

AbraCadaver
– AbraCadaver

2013-12-13 19:34:35 +00:00
Commented Dec 13, 2013 at 19:34 — AbraCadaver
– AbraCadaver, Commented Dec 13, 2013 at 19:34
Is "adding together" the same as SUM(assigndatx)?

DaSourcerer
– DaSourcerer

2013-12-13 19:34:56 +00:00
Commented Dec 13, 2013 at 19:34 — DaSourcerer
– DaSourcerer, Commented Dec 13, 2013 at 19:34
Why mysql_query? Legacy application?

tadman
– tadman

2013-12-13 20:01:58 +00:00
Commented Dec 13, 2013 at 20:01 — tadman
– tadman, Commented Dec 13, 2013 at 20:01
Did you give up on this one???

AbraCadaver
– AbraCadaver

2016-06-01 15:20:25 +00:00
Commented Jun 1, 2016 at 15:20 — AbraCadaver
– AbraCadaver, Commented Jun 1, 2016 at 15:20

AbraCadaver · Accepted Answer · 2013-12-13 19:48:40Z

6

$AssignDates = mysql_query("SELECT SUM(assigndatx) as total FROM opencall WHERE status < 2") $result = mysql_fetch_assoc($AssignDates); $total = $result['total'];

Also, I should add that you need to move away from mysql_ funcs and use mysqli_ or PDO.

edited Dec 13, 2013 at 19:48

answered Dec 13, 2013 at 19:36

AbraCadaver

79.2k7 gold badges75 silver badges91 bronze badges

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

1 Comment

Jessica Over a year ago

This is indeed the right way to do it, but the OP hasn't answered why he wants to do it in PHP and not MySQL. So it may not actually answer his question.

Trav · Accepted Answer · 2013-12-13 19:37:05Z

$sum = 0; while ($row = mysql_fetch_assoc($AssignDates) { $sum += $row['assigndatx']; } return $sum;

Joe Love · Accepted Answer · 2013-12-13 20:01:06Z

If you switched to mysqli, you could do:

$result= mysqli_query("select assigndatx from opencall where status < 2"); $rows= mysqli_fetch_all ($result, MYSQLI_ASSOC); echo array_sum($rows);

my personal preference would be to use

select sum(assigndatx) as total from opencall where status < 2

for the SQL and avoid doing it at all in php.

I don't understand the personal preference statement. If he needs to use the data in a PHP script, he has to get any data from the MySQL result set into PHP by using mysql/mysqli/PDO extensions.
Of course I'm assuming that it's the only thing that was needed.

Collectives™ on Stack Overflow

add integers from SQL column in php

3 Answers 3

1 Comment

Comments

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

2 Comments

Related