D
Dino
Hi all,
I am looking to create a program that will display user names with 25 users
per page.
I am looking to use the top 25 to get the users, in alphabetical order.
my concern is this. I am tracking the first and the last userid on the
page. if the user clicks next 25 then I simply use the top 25 where the
userid > the the last one on the page. that works!
However if the user clicks previous 25, I dont know how to the 25 records I
want to display ending with the record prior to the first one shown. is
there a Bottom 25 or Last 25 that I can use in the SQL statement? I have not
been able to find one, just looking for any help!
the database is currently about 1000 records and it is expecting to grow to
over 10000 users! I dont want to have to get all records before the last
one displayed and go back 25 prior to printing! hope this makes sense
thanks
I am looking to create a program that will display user names with 25 users
per page.
I am looking to use the top 25 to get the users, in alphabetical order.
my concern is this. I am tracking the first and the last userid on the
page. if the user clicks next 25 then I simply use the top 25 where the
userid > the the last one on the page. that works!
However if the user clicks previous 25, I dont know how to the 25 records I
want to display ending with the record prior to the first one shown. is
there a Bottom 25 or Last 25 that I can use in the SQL statement? I have not
been able to find one, just looking for any help!
the database is currently about 1000 records and it is expecting to grow to
over 10000 users! I dont want to have to get all records before the last
one displayed and go back 25 prior to printing! hope this makes sense
thanks