[thelist] SQL... group by prob...
Barry Woolgar
barry at burnthebook.co.uk
Tue Sep 18 08:40:14 CDT 2007
Hello again,
To clarify, the reason it _needs_ to be in backticks/quotes is because DATE
is a mysql function so its possible you're causing syntax errors. Of course
mysql doesn't stop you creating fields that have the same name as functions
so it’s a good idea not to use field names like 'order' or 'date' just in
case you forget about the quotes in the statement.
Barry
-----Original Message-----
From: thelist-bounces at lists.evolt.org
[mailto:thelist-bounces at lists.evolt.org] On Behalf Of Barry Woolgar
Sent: 18 September 2007 14:29
To: thelist at lists.evolt.org
Subject: Re: [thelist] SQL... group by prob...
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 !
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.487 / Virus Database: 269.13.22/1013 - Release Date: 17/09/2007
13:29
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