Getting dates between two dates and related information from the database.

[kigoobe]

Well guys, I am storing data in the mysql which when extracted gives this -

[PHP]Array
(
[0] => Array
(
[id] => 26
[date] => 2007-11-01
[time] => 16:01:00
[duration] => 08:00:00
[access] => ouvert
[description] => something goes here

)

[1] => Array
(
[id] => 17
[date] => 2007-11-03
[time] => 13:05:00
[duration] => 00:00:00
[access] => ouvert
[description] => something goes here.

)

[2] => Array
(
[id] => 18
[date] => 2007-11-03
[time] => 16:06:00
[duration] => 00:10:00
[access] => restreint
[description] => something goes here.

)

)[/PHP]

As you guys can see, data is related to a date and time, in each case.

Now, I have a start date and an end date. Say 2007-10-25 and 2007-11-06. I also have a function that gives the number of dates between the two dates.

The problem starts here. I want to print a different row for each date (between and including the start and end dates), and then depending on if data present against a given date, print it, or leave the row empty.

Wondering, what would be the smartest way of doing this...

Idea guys? Thanks for your time. :)

************************************************** ******

I just found a solution to the first part -
[PHP]for ($i=0;$i<=$diff;$i++) {
echo date("Y-n-d", mktime(0, 0, 0, $du2, $du3 + $i, (int)$du1))."<hr />";
}[/PHP]
is giving me the dates as I want :)

[kigoobe]

Well guys

Here's where I'm now. It's a working solution. if someone is looking for something similar, feel free to pick it up. However, not sure this is the fastest solution. Experts are requested to give their views.

[PHP]foreach ($result as $rex) {
$dateArr[] = $rex['date'];
}
for ($i=0;$i<=$diff;$i++) {
$chkDate = date("Y-n-d", mktime(0, 0, 0, $du2, $du3 + $i, (int)$du1));
echo $chkDate." => ";
if (isset($result)) {
foreach ($dateArr as $k=>$v) {
if ($chkDate == $v) {
echo $result[$k]['description'];
}
}
echo "<hr />";
} else {
echo NO_RDV;
}
}[/PHP]

where, $result holds the array of the first post. $du2 is month, $du3 is day and $du1 is year. $diff is the number of dates between the two dates.

Best.