I've been trying to find a way of doing this and have come up dry. Is this possible? If so could someone tell me how to go about this?
Ok, seems I've managed to sort my problem.
Adding "DESC LIMIT 1,1" to the end of my MySQL query selects the second last row in the table.
I did some fiddling with this and it seems that adding these two numbers together is going to give you the row you're looking for, so for instance if you want to retrieve the 4th row from the bottom then you would change "DESC LIMIT 1,1" to "DESC LIMIT 3,1".
Hope this helps anyone else having the same problem.