Number of days between 2 mysql dates

[SEO Voter]

Again I am always trying to improve my PHP scripts... Can anyone improve on this script or does anyone have a better one?

Code:

<?php

// returns the days between any 2 dates, any order
// date format required is mysql date format
// if date2 is null, then number of days between today and date1
function daysBtwDates ($date1, $date2 = null)
{
if ($date2 == null)
{
$date2 = date("Y-m-d");
}

if ($date1 >= $date2)
{
$date3array = explode("-", $date1);
$date4array = explode("-", $date2);
}
else 
{
$date3array = explode("-", $date2);
$date4array = explode("-", $date1);
}

return (int)((mktime(0,0,0,$date3array[1],$date3array[2],$date3array[0]) - mktime(0,0,0,$date4array[1],$date4array[2],$date4array[0]))/86400);
}
?>

Thanks wineo

[Join us @ facebook]

I think your code is ok.

Something you could change is the first line. Instead of

Code:

<?php
if ($date2 == null)
{
            $date2 = date("Y-m-d");
}
?>

you can say :

Code:

<?php
if ($date2 == null)
{
            return 0;
}
?>

Wineo, may I ask you why you have to know the number of days between two dates? (just courious)

[Join us @ facebook]

Wineo, may I ask you why you have to know the number of days between two dates? (just courious)

He. That's an interesting question

[SEO Voter]

HAHA... I am making a graph using gd libraries and I don't want the entries in the x axis to just be evenly spaced but instead proportionate to the number of day bewteen each entry.

Nikolas - I just added that bit of code so that i (or whoever needs it) can also work out the number of days between today and any date that I enter, whether in the past or future. I only have to pass in one date if I need to calculate this.

[Guest]

[38.000]

Googlebot, Yahoo crawler, Msnbot, Baidu Spider