Count the sum of raw in mysql table

Question

I want to get sum value of "number_of_date" in emp_leaves table, according to particular employee ID and make some variable to assign it's value. Following is my query.

 $resultOfcount= mysql_query("SELECT SUM(number_of_date) AS number_of_date FROM emp_leaves WHERE emp_id='$userID' && leave_category='$category");
             $value=mysql_fetch_array($resultOfcount);

             $value1=$value['number_of_date'];

But it makes some error which is

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in ..

How can I fix it, Please help.

Hint: It is not `&& leave_category` – juergen d May 15 '16 at 18:28 — juergen d, May 15 '16 at 18:28

score 1 · Accepted Answer · edited Jun 27 '16 at 07:06

1

You are missing a ' at the end of the WHERE part

$resultOfcount= mysql_query("SELECT SUM(number_of_date) AS number_of_date FROM emp_leaves WHERE emp_id='$userID' && leave_category='$category'");

Thatswhy the query fails and returns false

edited Jun 27 '16 at 07:06

marc_s

704,970
168
1,303
1,425

answered May 15 '16 at 18:28

Fabian N.

3,720
2
21
45

Thank u, I put that missing ' and now it works. – Chathurika May 16 '16 at 03:56

Count the sum of raw in mysql table

1 Answers1