2 replies to this topic

[charsta]

Hello,

I have a table that among other details it's store a start date and an end date. (Start date is "smaller" than end date!)
Is is possible to print out the dates that are in between start date and end date?
I am using MySQL (and i will try later to import this into php)

e.g.
Start date: 2012-01-01
End date: 2012-01-07

result
2012-01-01
2012-01-02
2012-01-03
2012-01-04
2012-01-05
2012-01-06
2012-01-07

Thanks in advance!

[gregwarner]

I believe comparison operators (greater than and less than) work correctly with MySQL date types, with greater than being further into the future and less than being further into the past, so comparing them just like integers should work.

[charsta]

This is how I did it in PHP
$query4 has as a result the starting date and
$query5 the end date.

$now = $query4;

while($now < $query5) {

  echo($now . '<br />');

  $now = date('Y-m-d', strtotime(date("Y-m-d", strtotime($now)) . " +1 day"));

}

I want to thank Vaielab that help me on this one!