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

Barry Woolgar barry at burnthebook.co.uk
Tue Sep 18 08:28:54 CDT 2007


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
 




More information about the thelist mailing list