Rav_g Rav_g - 7 months ago 31
SQL Question

SQL query TIMESTAMPDIFF with php not working

I try to take a date and do countdown untill that day like following:

The date i want to countdown to: 2016-05-1 00:00:00

Then i want to calculate the diff between the date and now so i can do countdown timer.

I have this:

date_default_timezone_set("Asia/Jerusalem");

if ($result = $db->query("SELECT TIMESTAMPDIFF(SECOND, NOW(), 2016-05-1 00:00:00)")) {

while($row = $result->fetch_array()) {
$currentTimeLeft= $row['TIMESTAMPDIFF(SECOND, NOW(), 2016-05-1 00:00:00)'];
}

echo json_encode($currentTimeLeft);
}


I dont understand why this returning empty,what wrong here?

Answer

I see quote issue in your query

try this

if($result = $db->query("SELECT TIMESTAMPDIFF(SECOND,NOW(),'2016-05-1 00:00:00') as datediff")) {

        while($row = $result->fetch_array()) {
                $currentTime = $row['datediff']; 
        }

 echo json_encode($currentTime);

I have added an alias "datediff" to the result column as well

Comments