Help with dates please.

[habbardone]

I am trying to show the number of days and hours left before a record expires
using php and mysql.

In my table the record was created with a Date field called create_date.
So when extracted I have $create_date.

The record is not displayed after becomming two weeks old.

When a client looks at his record i want to show how much time is left, in days and hours.

Something like :

$time_left = strtotime( "2 weeks") - ($today-$create_date) ;

but this doesn't work.

When echo $time_left I want it to say something like "3 days 5 hours"

Please help !
Thanks.

[devinemke]

if you can, you should use mySQL's DATEDIFF function.

[Installer]

You could also do this (I think DATEDIFF() only deals in days):

Extract the "create_date" field to "$create_date" using the MySQL UNIX_TIMESTAMP() function, then do something like this:

$day = 24 * 60 * 60;
$hour = 60 * 60;
$time_left = strtotime('+1 fortnight', $create_date) - $today;
$days_left = floor(($time_left) / $day);
$hours_left = round(($time_left - ($days_left * $day)) / $hour);
echo $days_left . ' days ' . $hours_left . ' hours';

Edit: "$today = time();", of course.