Paging using LIMIT to get last x amount of records

[Floodster]

Hi,
I'm using ASP & MySQL Server 5.0. I have currently got my paging to work by using the LIMIT command in my SQL. I can use this for my buttons FIRST, NEXT & PREVIOUS but I'm stuck at how to retrieve the last x amount of records as I don't know how many records there are in total unless I run a seperate SQL which I would prefer not to.

I've read other forums & they suggest using ORDER by xx DESC but I'm a bit unsure.

thanks.

 

[r937]

check out the FOUND_ROWS() function

r937.com | rudy.ca