9 replies to this topic

[lol33d]

hi guys

i want get last 10 records in database

this is my query

SELECT * FROM `mytable` WHERE `field` = '21' ORDER BY `id` ASC LIMIT 0, 10

but this query get top 10 records

i need get last 10 record with ASC by id

help me please

thank you

[WingedPanther]

What fields are in mytable? There are two ways to do this:
1) do a SELECT COUNT(*) first, and use that to determine how many records to skip
2) do a SELECT * FROM (SELECT * FROM `mytable` WHERE field = '21' order by `id` DESC LIMIT 0,10) order by `id` ASC

[lol33d]

thank you

i have a error

my fields are(id, field, name, session, date)

you said use this query?

SELECT * FROM (SELECT * FROM `mytable` WHERE field = '21' order by `id` DESC LIMIT 0,10) order by `id` ASC

Syntax error or access violation: 1248 Every derived table must have its own alias

help more please

[WingedPanther]

"Syntax error or access violation: 1248 Every derived table must have its own alias" - Google Search

[lol33d]

please query

[Orjan]

but the last 10 while sorting ASC must be the 10 first when sorting DESC? So just limit 10 on DESC.. or?

[WingedPanther]

The double query is just to resort it to ascending.

[amrosama]

why not just do :amr:

SELECT * FROM `mytable` WHERE `field` = '21' ORDER BY `id` DESC LIMIT 0, 10

Am I missing something?

[WingedPanther]

He cares about the order, for some reason.

[bbqroast]

Errr Winged, I think he just wants to get the last 10 results in any order.
You can tell by his grammar that he is really confused...