I have a table with news. Every news has a date (when the news were created).
I want to display the news in "chunks" based on the date they were created. Example:
13-mar-2002
Channel asylum seekers halt trains.
Frenchman must bury frozen parents.
Search ends for U.S. chopper crew.
12-mar-2002
Court delays Farrakhan ban verdict.
Lockerbie appeal verdict due.
.
.
.
And so on...
My SQL is today:
SELECT id, created, title FROM news GROUP BY created DESC
... but I have no clue if this is the right way or how to echo it out to the client :-(
Anyone have a code snippet I can use? Tnx in advance :-)
/Andrin
PS. And Yes... I have done a search and found that there are no really good answers out there ;-)
