Most recent entries, different order

[Igor Fedorow]

Hi,

I have a table containing a "time" and an "author" column. How is it possible
to select the 10 most recent entries, but sorted by "author"?

Thanks for any help!

[_dotTSim_]

"Igor Fedorow" <ig**********@NO.SPAM.obda.net> wrote in message news:<bk**********@newsreader1.netway.at>...

Hi,

I have a table containing a "time" and an "author" column. How is it possible
to select the 10 most recent entries, but sorted by "author"?

select * from your_table order by time desc, author asc limit 10;

[Sugapablo]

_dotTSim_ wrote:

select * from your_table order by time desc, author asc limit 10;

No, that won't work as first it'll order by time, then by author, which
doesn't really "sort by author".
--
Sugapablo
------------------------------------
http://www.sugapablo.com <--music
http://www.sugapablo.net <--personal

[_dotTSim_]

"Igor Fedorow" <ig**********@NO.SPAM.obda.net> wrote in message news:<bk**********@newsreader1.netway.at>...

Hi,

I have a table containing a "time" and an "author" column. How is it possible
to select the 10 most recent entries, but sorted by "author"?

select * from your_table order by time desc, author asc limit 10;

[Sugapablo]

_dotTSim_ wrote:

select * from your_table order by time desc, author asc limit 10;

No, that won't work as first it'll order by time, then by author, which
doesn't really "sort by author".
--
Sugapablo
------------------------------------
http://www.sugapablo.com <--music
http://www.sugapablo.net <--personal

[_dotTSim_]

Sugapablo <ru********@sugapablo.com> wrote in message news:<vn************@corp.supernews.com>...

_dotTSim_ wrote:

select * from your_table order by time desc, author asc limit 10;

No, that won't work as first it'll order by time, then by author, which
doesn't really "sort by author".

This query would work so:
first,will order result by time (the last 10 entries),
second, will order for each same entries (if exist) author...

infact won't work like wish our friend..

But with MySQl < 3.23.* and PHP i'll try this:
stored into an array (e.g $result[]) the result of this query:
"select time,author from your_table order by time desc, author asc limit 10;"

than fill an array like this: $entries[$result['author']]=$result['time'];

then order by name the array according to the index!
P.S. Sorry my bad english...i'm not enghlis/american!

[_dotTSim_]

Sugapablo <ru********@sugapablo.com> wrote in message news:<vn************@corp.supernews.com>...

_dotTSim_ wrote:

select * from your_table order by time desc, author asc limit 10;

No, that won't work as first it'll order by time, then by author, which
doesn't really "sort by author".

This query would work so:
first,will order result by time (the last 10 entries),
second, will order for each same entries (if exist) author...

infact won't work like wish our friend..

But with MySQl < 3.23.* and PHP i'll try this:
stored into an array (e.g $result[]) the result of this query:
"select time,author from your_table order by time desc, author asc limit 10;"

than fill an array like this: $entries[$result['author']]=$result['time'];

then order by name the array according to the index!
P.S. Sorry my bad english...i'm not enghlis/american!