how can i count specific field multi rows of mysql using php

Question

how can I count Mysql Field Rows?

For example I have table called student_attendance where we have 4 fields: absent, present, holiday, leave.

There is list of 10+ students, each student value will go to its own field, like if for one student we selected absent, 1 value will go to absent field and if someone select present, 1 value will go to present field.

Now what i want is

Each time attendance take, new row insert in student_attendance table for the student.

So if there are 10 Rows in student_attendance table, how can i + all of them

Like if there are 10 rows of present field, 3 rows are empty and 7 rows have 1 value, how can i count it so that the total value of specific field 1+1+1+1+1+1+1 can comes in php so it show 7 ?

What have you tried? What hasn't worked? What research have you done to solve this problem? The thing you're looking for is called an aggregate function. Did you know this term before? If not, go look it up. — Charles
– Charles, Commented Dec 28, 2012 at 10:24

Amr · Accepted Answer · 2012-12-28 11:43:16Z

1

    SELECT SUM(present) AS presence_days
    FROM student_attendance

This will result:

+---------------+
| presence_days |
+---------------+
| 7             |
|               |
+---------------+

Example SQL (Demo):

edited Dec 28, 2012 at 11:43

answered Dec 28, 2012 at 10:37

Amr

5,1797 gold badges52 silver badges68 bronze badges

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

1 Comment

Amr Over a year ago

@hakre Thank you for your addition, it is really useful especially the Demo

Sivagopal Manpragada · Accepted Answer · 2012-12-28 10:25:34Z

0

select count(*) from table_name where present_field=1;

answered Dec 28, 2012 at 10:25

Sivagopal Manpragada

1,67414 silver badges34 bronze badges

Comments

Saharsh Shah · Accepted Answer · 2012-12-28 10:39:19Z

0

Try this:

SELECT SUM(absent), SUM(present), SUM(holiday), SUM(leave) 
FROM student_attendance 
GROUP BY sudentId;

answered Dec 28, 2012 at 10:39

Saharsh Shah

29.1k9 gold badges53 silver badges85 bronze badges

Collectives™ on Stack Overflow

how can i count specific field multi rows of mysql using php

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related