date functions - how to find all available dates in range

[richcleverley]

Hi,

I have two variables; $fromdate and $todate.

I need to find all the dates for that range to check against a database table. So for example, I have $fromdate 26/9/2005 and $todate 4/10/2005, I need to get all the dates inbetween those two (I have put them in UK format dd/mm/yyyy in case anyone wonders).

How would I do this? I know that I want to hold them in an array to do the check afterwards, but am not too sure how to go about it in the first place.

Thanks

Richard

 

[hos2]

pfff here are some dat functions that retrieve the amount of days. then it's simple to loop through that amount of days add 1 day each time and add them in an array

http://nl2.php.net/manual/en/function.date.php

 

[KingCrab]

Can't you just use the database to do it for you?

SELECT field FROM table WHERE thisdate>=$fromdate and thisdate <= $todate

OR,

SELECT field FROM table WHERE thisdate between $fromdate and $todate

??

 

[richcleverley]

Thanks all,

Couldn't do it from the database as it the dates are held in three fields (year, month and day) so it is obviously quite difficult to check like that.

In the end, I found another thread in the forum that sorted me out.

For anyone else that want to have a look, here it is:

http://tek-tips.com/viewthread.cfm?qid=1076561

Works a treat (although I had to change it a bit to suit UK dates etc.)

Rich