Posted by Al on 01/21/06 20:23

Ken Robinson wrote:
> Try this simple function:
>
> <?php
> $date_array = date_range('10/20/2005','01/31/2006');
> $dates = "'" . implode("','",$date_array) . "'";
> echo $dates . "<br />\n";
>
> function date_range($sd,$ed)
> {
> $tmp = array()
> $sdu = strtotime($sd);
> $edu = strtotime($ed);
> while ($sdu <= $edu) {
> $tmp[] = date('Y-m-d',$sdu);
> $sdu = strtotime('+1 day',$sdu);
> }
> return ($tmp);
> }
> ?>
>
> Ken

That was my simple function :) Mine just got out of control with
comments and stuff...

As for the sql BETWEEN operator, I was thinking that too... but I'm not
100% on sql so I was just kinda thinking "surely it has a between
operator".

• Next in forum: Re: 2nd pair of eyes, simple ?
• Prev in forum: Re: CVS and FTP (excluding directories)
• Thread view: Re: how do you get a list of all dates between two dates more than a day apart?

[Reply to this message]