Rav_g Rav_g - 2 years ago 102
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:


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 Source

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

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download