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.
