0

Hi all

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?

Much appreciated
Venom Rush

1
Contributor
1
Reply
3
Views
8 Years
Discussion Span
Last Post by Venom Rush
0

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.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.