This content has been marked as final. Show 3 replies
Processing the entire query at once is a good idea. Stuffing the data into an array is unnecessary. It is a lot less work to either cache the query or make it a session variable.
Once again you demonstrate your mastery. To tell you the truth, I had not thought of processing the entire query and putting what I need into an array until I was composing my question. Since it was very late and I did not get any responses after an hour, I decided to try it. So, I wrote the code using the array approach and making it and several other variables session variables and it works great. The one benefit of creating the array is that I do not have to redo the processing of the array as the user changes pages and all I have to pass through is the current page number the user is viewing.
Thanks again for your response.
Oops. I meant to say that the benefit of the array approach is that I do not have to reprocess the query info each time and it would still leave me with the dilemma of trying to figure out what info to pass so I did not have to refigure everything before the user could display the page wanted.