On Thu, Jul 03, 2003 at 11:19:14 -0400, Michael Hanna <zen@xxxxxxxx> wrote: > > Often there are multiple entries per day. I want to display the day > once, with all the entries on that day. > > So do I select * from notes and group by date, then write a nested > for-loop in php that ignores the extra timestamp items? Seems a little > inelegant. Or can I select distinct timestamps somehow after converting > them to dates? I think the normal thing to do here is have the application check that the date for the current row is the same as for the previous row and suppress the date in that case. If the repeated information was large enough that just transferring the rows from the backend to the frontend was the bottleneck, then you might be better off getting the list of per information in a cursor and then for each day get the records for that day. I can't imagine this being the case if the only redundant information was the date.
