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?
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.
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.
All the buzzt CornedBee
"Writing specifications is like writing a novel. Writing code is like writing poetry."
- Anonymous, published by Raymond Chen
Don't PM me with your problems, I scan most of the forums daily. If you do PM me, I will not answer your question.
Reply With Quote
CornedBee