How do I calculate days between to dates?

[Anon]

I am trying to build a site that removes items after a while.

Say that I want to display some records from a MySQL database, as long as it has been updated or created within e.g. 40 days. So I need to calculate how many days that are between the actual day (now) and the date that the record was last updated/created.

How do I do that? I guess you cannot just subtract one date from another? (Well, I actually have tried that....) I read something about storing the date as an int, and so i did....but....I'm stuck....

Thanks!

Torbjørn

[Anon]

I think what you need is to use timestamp to subtract the date. I tried it, it worked.

$old_date = '9/10/2000';
$l1 = explode("/",$ddate);
$old_date_mktime = mktime(0,0,0,$l1[0],$l1[1],$l1[2]);
$today_mktime = mktime( 0, 0, 0, date("m"), date("d"), date("Y") );
$diff = $today_mktime - $old_date_mktime;
$diff_day = date('d', $diff);
echo $diff_day;

[Anon]

Maybe u have missed it but there is a article how to calculate it.. take a look here: http://www.phpbuilder.net/columns/akent20000610.php3?page=7

[Anon]

Thanks a lot, both of you!

After some testing, I made it work with Jamie's suggestion!

One less problem - time to meet the next! :-)

Torbjørn

[Anon]

Thanks a lot too,

I was also looking for it.

Ibrahim

[stevenrhiggins]

Date calculations are much easier when done using a database query. Mysql, for example, has excellent date calculations that make life much simpler than doing it throught PHP