[thelist] SQL... group by prob...

[Tris]

Ello...

We've a table.. (lucky us)

offer_id, date

it's populated with many offer_id's (we've say 20 offers)
and each time a user digns up, we flag what offer and the date (Unix time stamp)

What we want to do is list each offer_id (group by offer_id)
but lsit the most recent date for each unique offer listing...

Am I being a tool...?
GROUP BY offer_id ORDER BY date DESC doesn't work...

how can I do this? :-(




-- 
Give a man a fish and he'll feed himself for a day.
Give a man a religion and he'll starve to death praying for a fish.
Anon

`We are what we pretend to be, so we must be careful what we pretend to be.`
Kurt Vonnegut

`When a person can no longer laugh at himself, it is time for others
to laugh at him.`
Thomas Szasz