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

[Tris]

Yes.. in my query I AM using backticks...
I jsut didn't write them down in this mail, to save time...

for the record, my query is this:

SELECT * FROM `orders` WHERE `percent` > 0 GROUP BY `offer_id` ORDER
BY `date` DESC

though if there's 100 entries of offer_id 12 (eg) and date ranges over
several months, we always just get the last date in the DB... but we
need to sort by that date too...





On 18/09/2007, Barry Woolgar <barry at burnthebook.co.uk> wrote:
> 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
>
>
> --
>
> * * 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.
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