[SOLVED]How can I find out what page a particular record is
Posted: Mon Mar 12, 2007 12:58 pm
I am using record paging with the limit clause and a paginate menu.
What I would like to do is be able to have someone fill in a text box with an identifier, then have the script 'jump' to the page that that identifier appears on.
For instance, if there are 4537 pages with 40 records each, and the user wants to go the page with bin JG16, they won't have to hunt through page after page.
I could implement a search, but I would really prefer to be able to jump to a specific page so that they can continue where they left off if for instance they are spending a week doing inventory and would like to start back where they left off.
The problem is the number of records which is currently about 45,000. I do not want to have to query them all to find out where the record lies. Is this possible to do?
What I would like to do is be able to have someone fill in a text box with an identifier, then have the script 'jump' to the page that that identifier appears on.
For instance, if there are 4537 pages with 40 records each, and the user wants to go the page with bin JG16, they won't have to hunt through page after page.
I could implement a search, but I would really prefer to be able to jump to a specific page so that they can continue where they left off if for instance they are spending a week doing inventory and would like to start back where they left off.
The problem is the number of records which is currently about 45,000. I do not want to have to query them all to find out where the record lies. Is this possible to do?