[Resolved] Calculate seconds from NOW to END

[bengt]

I have tried to search, but when I don't know exactly what to search for...

I need to calculate how many seconds there is from now() to a date i Extract from a table.

Anyone?

[onion2k]

$seconds = mktime(<the date from the database>) - mktime();

[man]mktime/man generates the timestamp of your date in the future when you feed in the details from the database.

Alternatively, do the whole thing in SQL:

select (UNIX_TIMESTAMP(date) - UNIX_TIMESTAMP(NOW())) as seconds_until_date from table

[bengt]

I solved it this way

$result = mysql_query($sql) or die("Error: ".mysql_error());
$auc = mysql_fetch_array($result);
$endsec = strtotime($auc[end]);
$nowsec = getdate();
$nowsec = $nowsec[0];
$diffsec = $endsec - $nowsec;

Where $auc[end] ist the sql timestamp raw from table...