[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