php add values and print

Question

I have a sql table formatted like this:

YES NO
1 0
0 1
1 0

and I'm trying to add up the yes and the no columns, then print the result. My current code looks like this:

$sql = "select sum(yes) from votes";
$sql = "select sum(no) from votes";

Any help?

EDITS: (responses to comments)
YES and NO are INT.
I get no error. It's just a blank screen.
I do not echo the results. The code above is the only code that has to do with this part.

Any error you are getting? or what result it's showing?. As per your code you $sql variable is only going to have the sum of "no" — Kuru
– Kuru, Commented May 19, 2017 at 4:51
what is the data type of the YES & NO column? It should be numeric data type and make sure the case type(upper/lower) in the query... — Naga
– Naga, Commented May 19, 2017 at 4:52

CodeGodie · Accepted Answer · 2017-05-19 04:57:46Z

1

You should be able to sum both columns needed:

SELECT SUM(yes) AS yesSum, SUM(no) AS noSum FROM votes

answered May 19, 2017 at 4:57

CodeGodie

12.2k6 gold badges40 silver badges66 bronze badges

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

Collectives™ on Stack Overflow

php add values and print

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