Member Avatar for Venom Rush

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
  • 82 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by Venom Rush
Member Avatar for Venom Rush

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.