Increment Date

[tedtsoi]

Recently, I am working on a hotel reservation system. And I would like to generate a table of number of reserved room on each date with the data (arrival date and departure date) in the reservation database table.

The pseudo code: ~
############################################
$date = '2002-01-01';

mysql = "SELECT COUNT(*) FROM RERSERVATION
WHERE arrival_date <= $date
AND $date <= departure_date";

for( ; $date != '2002-12-31'; ++$date) {
$result = mysql_query($mysql_query);

$res_no = mysql_fetch_row($result);
echo $date."~".$res_rc[0]."<BR>";

}
############################################

Is it efficient to do so???

[tedtsoi]

I want to ask how to increment the Date one by one properly in the for-loop.

[Anon]

for($i = 0; $i <365; $i++) {
echo date("Y-m-d", mktime( 0, 0, 0, $month, 1 + $i, $year);
}