looping until today

[pauld]

I want to loop through dates, stopping at the current date

I set the enddate like this
$enddate=date('Y-m-d');

which prints out as '2006-04-01'

$l['cc_startdate'] comes from a DB with the column in date format

but when i do
for ($dl=$l['cc_startdate'];$dl < $enddate;$dl++)
{
print $dl;
blah

}

it goes on until the day is 99 and then loops again.
so how do I tell it that $enddate is in the same date format asthe
start date

[Carl Vondrick]

To convert a string to a date, you can use strtotime() to make a timestamp.

So, for example:

echo date ('Y-m-d',strotime('8:30 PM'));

pauld wrote:

I want to loop through dates, stopping at the current date

I set the enddate like this
$enddate=date('Y-m-d');

which prints out as '2006-04-01'

$l['cc_startdate'] comes from a DB with the column in date format

but when i do
for ($dl=$l['cc_startdate'];$dl < $enddate;$dl++)
{
print $dl;
blah

}

it goes on until the day is 99 and then loops again.
so how do I tell it that $enddate is in the same date format asthe
start date

--
Carl Vondrick
Web-Engineer
www.carlsoft.net

[Geoff Berrow]

Message-ID: <11**********************@z34g2000cwc.googlegroups .com> from
pauld contained the following:

it goes on until the day is 99 and then loops again.
so how do I tell it that $enddate is in the same date format asthe
start date

Use timestamps

$enddate=strtotime('now');

for ($dl=strtotime('2006-3-1');$dl < $enddate;$dl=$dl+24*60*60)
{
print date('Y-m-d',$dl)."<br>";

}
--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

[pauld]

i tried strtitme("now ") which prints 1143878058 but the loop still
goes round and round
with

$date=("Y-m-d");
$enddate=strtotime($date);

it prints -1 and no loop at all.

[pauld]

thank you . I also need to use the date format as a lookup in an sql
query

end result that works

$date=("now");
$enddate=strtotime($date);
//print he dates from start date to present
for ( $dl=strtotime($l['cc_startdate']) ;$dl < $enddate ;
$dl=$dl+24*60*60)
//for ($dl=$l['cc_startdate'];$dl < $enddate;$dl++)
{$dlookup=date('Y-m-d',$dl);
//////////////////cell for date
print '<tr><td>'.$dlookup.'</td>';
print '<td>';
{
$sql2='SELECT * FROM table WHERE date=\''.$dlookup.'\'';

etc