I have been trying to sum all the value of a column in php..but it isn't working..
$query="SELECT SUM(total_earnings) as `total` from daily_report";
$res=mysqli_query($connect,$query);
$data=mysqli_fetch_assoc($res);
echo $data['total'];
Asked
Active
Viewed 62 times
0
Barmar
- 669,327
- 51
- 454
- 560
Ishteaque Ahmed
- 9
- 1
-
What is the exact error message? – Tim Biegeleisen May 31 '19 at 01:18
-
Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in D:\phplocalserver\www\agents\agent_report.php on line 19 – Ishteaque Ahmed May 31 '19 at 01:23
-
Add `or die(mysqli_error($connect)` to the end of the `mysqli_query` line to see the reason. – Barmar May 31 '19 at 01:23
-
See https://stackoverflow.com/questions/2546314/php-mysql-mysqli-num-rows-expects-parameter-1-to-be-mysqli-result-boolean?noredirect=1&lq=1 – Barmar May 31 '19 at 01:25
-
The problem is not in the query, but in the connection : having a boolean in parameter 1 means that your connection returns false – Joffrey Schmitz May 31 '19 at 07:27