Loops

[ktucker]

Is it possible to use a date in a while loop. I am trying to get a list of all dates between two seperate dates. Any suggestions?

[toma42]

pear.php.net has a great library, Date.php , which is good for date math.

You could also take todays date then add 86400 to it for each day you want to loop thorugh.

[mcgruff]

I could be wrong but using a PEAR class sounds like taking a hammer to crack an egg. It should be possible to do this more efficiently with query logic.

Unix timestamps are often the easiest way to work with dates - use php date() function to format them any way you like for browser output.

How do you get the two dates? For example:

mktime(0, 0, 0, $month, $day, $year)

.. lets you create a timestamp from, say, integer values entered from a form field (such as 01, 08 and 2003).

If timestamps for the items you are looking for are stored in a mysql integer column, all you have to do next is create a query to find an integer between the upper and lower values.

Just one caveat: Unix timestamps (in seconds) start from 1st Jan 1970 (I think - damn I should know that) and so ain't any use if you need to go further back in time.

[ktucker]

I get the dates from a url. That actually come from a form on another page. However they are entered by month, day, year seperately.

[diego25]

Then use the mktime() method that mcgruff described.

Diego

[ktucker]

How do you display each date in a column on a table? What I am needing to have displayed is a rate associated with each date.