List:MySQL on Win32« Previous MessageNext Message »
From:Christian Mack Date:September 9 1999 7:43pm
Subject:Re: Making a "pretty" list
View as plain text  
John Corbin wrote:
> 
> Is there a way that I can create a list that is split into days? I want all
> items from the last 7 days (TO_DAYS(NOW()) - TO_DAYS(last_update) <= 7)  but
> I'd like to have the day's heading before each day (i.e. Sunday Sep
> 5th)...is this possible with mySQL???
> 
> So I would wind up with:
> 
> Sunday Sep 5th
> item
> item
> item
> 
> Saturday Sep 4th
> item
> item
> item
> 
> Friday Sep 3rd
> item
> item
> 
> etc........
> 
> any help is much appreciated.
> John

Hi John

No, you just can get the day with each item and print the heading lines yourself.

Tschau
Christian

PS: Sorry for the late answer, I was really busy.

Thread
Making a "pretty" listJohn Corbin5 Sep
  • Re: Making a "pretty" listChristian Mack9 Sep