Printable View
What would be the best way to step through a few thousand records?
The way I'm doing it currently is to have an identifier field and everytime a user clicks a link or a button, it grabs the next record based on that identifier.
Would it be easier to stuff the entire table into an array and just pull from the array?
I'm not sure where to go on this one.
are you searching through them or taking anything from them or what?
is this a stupid question? i don't exactly get what you're doing..
Do you want to display them one per page, or all on one (or a few) page(s)?
Well, I'm converting an Access DB to a PHP/MS SQL Server solution and in Access, they can scroll left and right and show one record at a time (which contains about 20 items on what looks like a form). I'd like to do the same thing, but on the web. They're not in any particular order right now, and I'll be adding a search feature since there are a good 2500 records.
Does that make it clearer?
No. Can you post a screenshot of what the Access thing does?
Access operation:
web solution:
Well, since an array doesn't persist between pages and you want to minimize the data transfer between the DB and your script, your current approach sounds good.