grouping by date...

[dodgyone]

I have a field in MySQL that contains the date. I have ordered the sql query into date order ascending.

What I would like to do is when displaying the records is to distinguish that the same date has ended and new date has begun. This is so that I can put each date series into a box (table with a border).

So that each day in the week is displayed with a box around it.


Any ideas?

Thanks...

 

[piti]

what about checking the previous and the current displayed date?
$prevdate = '1900-01-01';
while ($row = mysql_fetch_array($result)) {
if ($prevadate!=$row['datecolumn']) {
//end table and start new one
} else {
//add new line
}
$prevdate = $row['datecolumn']
}