select from the bottom of a table?

[Knifee]

I have a table and i want to select the last 5 results.. but i want them ordered asc

ie

if i had these records:

record 1
record 2
record 3
record 4
record 5
record 6
record 7

i would like to get

record 4
record 5
record 5
record 6
record 7

as the result of my query. At the moment i can only get the last 5 by ordering the results desc and using a Limit which orders them 7,6,5,4.

Is there a way to do this useing sql? if not can any1 surgest a way to reorder the results once i get them?

[LordShryku]

Put the results in an array, then you can loop to display them any way you want to