[SOLVED] retrieve one before the last entry

[dannybrazil]

Hello

i understand how to retrieve the last entry with DESC and LIMIT 1

 

but is there any way to get the second to last entry ?

not the second AND last, JUST the second to last

 

Danny

[asmith]

Go exactly like DESC and LIMIT 1, but instead of LIMIT 1 do this:

 

LIMIT 1,1

 

(LIMIT 1 actually is LIMIT 0,1)

[dannybrazil]

Cool thanks

i'll try that and let you know

[dannybrazil]

yeap...all good

thanks again

[asmith]

np

 

Please use the Topic Solved button (at the bottom left of the page) if your question is entirely solved.