SEO

#1 (**permalink**) 04-17-2008, 04:09 PM

I keep track of some documents for work, and have built an rss feed to
show the most recent 20. A simplified version of the query is here:

SELECT date_created, id, name
FROM documents
ORDER BY date_created desc
LIMIT 0, 20

This will show the most recent documents, with the most recent on the
top. Is it possible to reverse the order of these last twenty?

I'd like to have a list of the most recent documents, ordered ascending.

Thanks,
Charley

#2 (**permalink**) 04-17-2008, 04:09 PM

On 17 Apr, 00:21, cami...@mit.edu wrote:
> I keep track of some documents for work, and have built an rss feed to
> show the most recent 20. A simplified version of the query is here:
>
> SELECT date_created, id, name
> FROM documents
> ORDER BY date_created desc
> LIMIT 0, 20
>
> This will show the most recent documents, with the most recent on the
> top. Is it possible to reverse the order of these last twenty?
>
> I'd like to have a list of the most recent documents, ordered ascending.
>
> Thanks,
> Charley

Here is one way:
SELECT * FROM (
SELECT date_created, id, name
FROM documents
ORDER BY date_created desc
LIMIT 0, 20 ) AS md
ORDER BY date_created

#3 (**permalink**) 04-20-2008, 02:49 PM

"Captain Paralytic" <paul_lautman@yahoo.com> wrote in message
news:989c7cc7-9b6e-4912-958e-dfbd7ff524ee@y21g2000hsf.googlegroups.com...
> On 17 Apr, 00:21, cami...@mit.edu wrote:
>> I keep track of some documents for work, and have built an rss feed to
>> show the most recent 20. A simplified version of the query is here:
>>
>> SELECT date_created, id, name
>> FROM documents
>> ORDER BY date_created desc
>> LIMIT 0, 20
>>
>> This will show the most recent documents, with the most recent on the
>> top. Is it possible to reverse the order of these last twenty?
>>
>> I'd like to have a list of the most recent documents, ordered ascending.
>>
>> Thanks,
>> Charley
>
> Here is one way:
> SELECT * FROM (
> SELECT date_created, id, name
> FROM documents
> ORDER BY date_created desc
> LIMIT 0, 20 ) AS md
> ORDER BY date_created

How do you read the data?

If its stored in a collection, would it be easy to reverse the order you
iterate it?

--
Tony
http://www.mccreath.org.uk

#4 (**permalink**) 04-24-2008, 06:09 PM

Tigger wrote:
> "Captain Paralytic" <paul_lautman@yahoo.com> wrote in message
> news:989c7cc7-9b6e-4912-958e-dfbd7ff524ee@y21g2000hsf.googlegroups.com...
>> On 17 Apr, 00:21, cami...@mit.edu wrote:
>>> I keep track of some documents for work, and have built an rss feed to
>>> show the most recent 20. A simplified version of the query is here:
>>>
>>> SELECT date_created, id, name
>>> FROM documents
>>> ORDER BY date_created desc
>>> LIMIT 0, 20
>>>
>>> This will show the most recent documents, with the most recent on the
>>> top. Is it possible to reverse the order of these last twenty?
>>>
>>> I'd like to have a list of the most recent documents, ordered ascending.
>>>
>>> Thanks,
>>> Charley
>> Here is one way:
>> SELECT * FROM (
>> SELECT date_created, id, name
>> FROM documents
>> ORDER BY date_created desc
>> LIMIT 0, 20 ) AS md
>> ORDER BY date_created
>
> How do you read the data?
>
> If its stored in a collection, would it be easy to reverse the order you
> iterate it?
>

I'm spitting it out with php - the nested selects are probably the
easiest, but I've thought about reversing it after i grab it from mysql,
too.

#5 (**permalink**) 04-24-2008, 06:09 PM

On 20 Apr, 13:30, "Tigger" <mccre...@bigfoot.com> wrote:
> "Captain Paralytic" <paul_laut...@yahoo.com> wrote in message
>
> news:989c7cc7-9b6e-4912-958e-dfbd7ff524ee@y21g2000hsf.googlegroups.com...
>
>
>
> > On 17 Apr, 00:21, cami...@mit.edu wrote:
> >> I keep track of some documents for work, and have built an rss feed to
> >> show the most recent 20. A simplified version of the query is here:
>
> >> SELECT date_created, id, name
> >> FROM documents
> >> ORDER BY date_created desc
> >> LIMIT 0, 20
>
> >> This will show the most recent documents, with the most recent on the
> >> top. Is it possible to reverse the order of these last twenty?
>
> >> I'd like to have a list of the most recent documents, ordered ascending.
>
> >> Thanks,
> >> Charley
>
> > Here is one way:
> > SELECT * FROM (
> > SELECT date_created, id, name
> > FROM documents
> > ORDER BY date_created desc
> > LIMIT 0, 20 ) AS md
> > ORDER BY date_created
>
> How do you read the data?

I don't read it. I did not post the question.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

reversing the order of a limited query