[eluser]chrisco23[/eluser]
Sophistry,
Thanks for the tip. I'm going to look more closely at the pagination stuff today. I implemented it initially about a year in development and since we launched in November, the result sets have been small enough that it hasn't become a bothersome problem until now.
I was thinking I'd store the result IDs in a session variable as you say. Right now that would be integers, approximately #1 - 300. If the site should really take off, I could not see the number ever growing beyond 5000 or so, but still that seems like a lot to carry around in a $_SESSION.(?)
Can you explain where array_multisort() comes into the picture though? The result of the query will be a random order, but I just need to keep that same order throughout the pagination. I'm not sure how the multisort facilitates that.(?)
Thanks,
Chris
P.S. Did everyone's posts get wiped out and reset when the new version of codeigniter got launched? I guess I found codeigniter to be so solid and intuitive that I haven't had any questions since before then
