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

Tris beertastic at gmail.com
Tue Sep 18 08:32:30 CDT 2007

Yeah, sorry I simplified hte query for ease of typing...
we've done all that.. we're not getting errors, but it's jsut not
sorting the date at all...

it's very frustrating...!

On 18/09/2007, Barry Woolgar <barry at burnthebook.co.uk> wrote:
> Ello...
> > Am I being a tool...?
> > GROUP BY offer_id ORDER BY date DESC doesn't work...
> Are you getting a specific SQL error? I'm pretty sure you need to put 'date'
> in backticks for it to be valid, ie:
> ... GROUP BY `offer_id` ORDER BY `date` DESC
> Barry
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.5.487 / Virus Database: 269.13.22/1013 - Release Date: 17/09/2007
> 13:29
> --
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !

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.

`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

More information about the thelist mailing list