计算不同日期时间值的SUM

Question

I have several datetime queries. I need to get the SUM and display user side. How can I achieve this?

queries

    $sqlmon="SELECT * , TIMEDIFF(t.timeouthour, t.timeinhour) AS Duration 
    FROM timesheets t 
    WHERE employee_id='$session_myemployeeid' 
    AND timeinyear='$currentyear' 
    AND timeinmonth='$currentmonth' 
    AND timeinday='Monday' ";
    $resultmon=mysqli_query($db,$sqlmon);

    $sqltues="SELECT * , TIMEDIFF(t.timeouthour, t.timeinhour) AS Duration 
    FROM timesheets t WHERE employee_id='$session_myemployeeid' 
    AND timeinyear='$currentyear' 
    AND timeinmonth='$currentmonth' 
    AND timeinday='Tuesday' ";
    $resulttuesday=mysqli_query($db,$sqltues);
    [5 more...]

I tried this but it does not work...

Total :  <?=$timemonday['Duration']+$timetuesday['Duration'];?>

Answer 1

I found the answer here :

$sqlmon="SELECT *, SUM(TIMEDIFF(t.timeouthour, t.timeinhour)) 
AS Duration FROM timesheets t 
WHERE employee_id='$session_myemployeeid' 
AND timeinyear='$currentyear' 
AND timeinmonth='$currentmonth' 
AND timeinday='Monday' ";
$resultmon=mysqli_query($db,$sqlmon);